存储过程在IIS服务器上不工作，而在ASP.NET MVC中的localhost上正常工作

Question

有人能帮我吗？我在这个过程中创建了一个从存储过程中获取数据的方法，用户选择月份、年份和地区，它将显示该地区的用户数量，它在本地主机上运行良好，但当我将其上传到服务器时，它不再正常工作。

[HttpPost]
public ActionResult get_Data_with_months(int did, string month, string year)
{
string dateset = "01" + "/" + month + "/" + year;
//string dateset = month + "/01/" + year;
DateTime date = Convert.ToDateTime(dateset);
DateTime firstDayOfMonth = new DateTime(date.Year, date.Month, 1);
DateTime lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
// string second = Did;
string first = Convert.ToDateTime(firstDayOfMonth).ToString("MM/dd/yyyy");
string last = Convert.ToDateTime(lastDayOfMonth).ToString("MM/dd/yyyy");
var Monthwisetkt = db.spWitnessDataMonthwise(first, last, did).ToList();
ViewBag.count = Monthwisetkt.Count;
//Creating table for response data
StringBuilder DistrictTbl = new StringBuilder();
int count = 1;
int j = 0;
//DistrictTbl.Append("<b>"+ month + year+ "Witness List</b>");
DistrictTbl.Append("<div class='col-md-12 m-auto'><table class='table table-bordered' id='tbl-data'><thead><tr><th>S.No.</th><th>District Name</th><th>No of  Witness </th></tr></thead><tbody>");
foreach (var item in Monthwisetkt)
{
var DistrictName = Monthwisetkt.ElementAt(j).District_name;
var no_of_witness = Monthwisetkt.ElementAt(j).NoOfWitness;
DistrictTbl.Append("<tr><td>"+ count + "</td><td>"+ DistrictName + "</td><td>"+ no_of_witness + "</td></tr>");
j++;
count++;
}
DistrictTbl.Append("</tbody></table></div>");
return Json(new { result = "True", msg = DistrictTbl.ToString() });
}

存储过程：

ALTER PROCEDURE [dbo].[spWitnessDataMonthwise] 
(@fromDate nvarchar(50),  
@toDate nvarchar(50), 
@DistrictId int) 
AS 
SELECT 
id, District_name, 
(SELECT COUNT(*) 
FROM WHD_witness 
WHERE District_Name = dtable.id 
AND insert_date BETWEEN @fromDate AND @toDate 
AND dtable.id = @DistrictId) AS NoOfWitness 
FROM 
WHD_district dtable 
WHERE 
dtable.id = @DistrictId 

Answer 1

问题是服务器正在以yyyy-mm-dd格式获取日期，所以我更改了传递给函数的输入字符串的格式。