if (model.Sex == null) { parameters[0].Value = 0; } else { parameters[0].Value = model.Sex; }
parameters[1].Value = model.BaseUnit;
parameters[2].Value = model.SingletonUnit;
parameters[3].Value = model.Spec;
if (model.AvailDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[4].Value = "" + maxYear + "-01-01 0:00:00"; } else { parameters[4].Value = model.AvailDate; }
if (model.DrugName == null) { parameters[5].Value = ""; } else { parameters[5].Value = model.DrugName; }
if (model.DrugId == null) { parameters[6].Value = ""; } else { parameters[6].Value = model.DrugId; }
if (model.BatchNum == null) { parameters[7].Value = ""; } else { parameters[7].Value = model.BatchNum; }
//if (model.PubNumber == 0) { parameters[8].Value = 0; } else { parameters[8].Value = Convert.ToInt32(model.PubNumber); }
parameters[8].Value = string.IsNullOrEmpty(model.PubNumber.ToString()) ? 0 : Convert.ToInt32(model.PubNumber);
if (model.Ration == null) { parameters[9].Value = ""; } else { parameters[9].Value = model.Ration; }
if (model.Birthday == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[10].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[10].Value = model.Birthday; }
if (model.InCode == null) { parameters[11].Value = ""; } else { parameters[11].Value = model.InCode; }
if (model.DptId == null) { parameters[12].Value = ""; } else { parameters[12].Value = model.DptId; }
if (model.InDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[13].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[13].Value = model.InDate; }
if (model.UseDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[14].Value = "" + maxYear + "-01-01 0:00:00"; } else { parameters[14].Value = model.UseDate; }
if (model.IDcard == null) { parameters[15].Value = ""; } else { parameters[15].Value = model.IDcard; }
if (model.PName == null) { parameters[16].Value = ""; } else { parameters[16].Value = model.PName; }
if (model.HoldAddressDetails == null) { parameters[17].Value = ""; } else { parameters[17].Value = model.HoldAddressDetails; }
if (model.PolicyName == null) { parameters[18].Value = ""; } else { parameters[18].Value = model.PolicyName; }
//if (model.InTimes == null) { parameters[19].Value = 0; } else { parameters[19].Value = Convert.ToInt32(model.InTimes); }
parameters[19].Value = string.IsNullOrEmpty(model.InTimes.ToString()) ? 0 : Convert.ToInt32(model.InTimes);
if (model.AddTime == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[20].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[20].Value = model.AddTime; }
if (model.AddBy == null) { parameters[21].Value = ""; } else { parameters[21].Value = model.AddBy; }
if (model.AddIp == null) { parameters[22].Value = ""; } else { parameters[22].Value = model.AddIp; }
if (model.UpdateTime == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[23].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[23].Value = model.UpdateTime; }
if (model.UpdateBy == null) { parameters[24].Value = ""; } else { parameters[24].Value = model.UpdateBy; }
if (model.UpdateIp == null) { parameters[25].Value = ""; } else { parameters[25].Value = model.UpdateIp; }
if (model.Re == null) { parameters[26].Value = ""; } else { parameters[26].Value = model.Re; }
if (model.IsPassed == null) { parameters[27].Value = ""; } else { parameters[27].Value = model.IsPassed; }
if (model.IsCheck == null) { parameters[28].Value = ""; } else { parameters[28].Value = model.IsCheck; }
if (model.SourceType == null) { parameters[29].Value = ""; } else { parameters[29].Value = model.SourceType; }
if (model.Nation == null) { parameters[30].Value = ""; } else { parameters[30].Value = model.Nation; }
parameters[31].Value = Guid.NewGuid(); int obj = db.ExecuteNonQuery(strSql.ToString(), parameters);
求解,求高手,求细心!!!
parameters[1].Value = model.BaseUnit;
parameters[2].Value = model.SingletonUnit;
parameters[3].Value = model.Spec;
if (model.AvailDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[4].Value = "" + maxYear + "-01-01 0:00:00"; } else { parameters[4].Value = model.AvailDate; }
if (model.DrugName == null) { parameters[5].Value = ""; } else { parameters[5].Value = model.DrugName; }
if (model.DrugId == null) { parameters[6].Value = ""; } else { parameters[6].Value = model.DrugId; }
if (model.BatchNum == null) { parameters[7].Value = ""; } else { parameters[7].Value = model.BatchNum; }
//if (model.PubNumber == 0) { parameters[8].Value = 0; } else { parameters[8].Value = Convert.ToInt32(model.PubNumber); }
parameters[8].Value = string.IsNullOrEmpty(model.PubNumber.ToString()) ? 0 : Convert.ToInt32(model.PubNumber);
if (model.Ration == null) { parameters[9].Value = ""; } else { parameters[9].Value = model.Ration; }
if (model.Birthday == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[10].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[10].Value = model.Birthday; }
if (model.InCode == null) { parameters[11].Value = ""; } else { parameters[11].Value = model.InCode; }
if (model.DptId == null) { parameters[12].Value = ""; } else { parameters[12].Value = model.DptId; }
if (model.InDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[13].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[13].Value = model.InDate; }
if (model.UseDate == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[14].Value = "" + maxYear + "-01-01 0:00:00"; } else { parameters[14].Value = model.UseDate; }
if (model.IDcard == null) { parameters[15].Value = ""; } else { parameters[15].Value = model.IDcard; }
if (model.PName == null) { parameters[16].Value = ""; } else { parameters[16].Value = model.PName; }
if (model.HoldAddressDetails == null) { parameters[17].Value = ""; } else { parameters[17].Value = model.HoldAddressDetails; }
if (model.PolicyName == null) { parameters[18].Value = ""; } else { parameters[18].Value = model.PolicyName; }
//if (model.InTimes == null) { parameters[19].Value = 0; } else { parameters[19].Value = Convert.ToInt32(model.InTimes); }
parameters[19].Value = string.IsNullOrEmpty(model.InTimes.ToString()) ? 0 : Convert.ToInt32(model.InTimes);
if (model.AddTime == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[20].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[20].Value = model.AddTime; }
if (model.AddBy == null) { parameters[21].Value = ""; } else { parameters[21].Value = model.AddBy; }
if (model.AddIp == null) { parameters[22].Value = ""; } else { parameters[22].Value = model.AddIp; }
if (model.UpdateTime == Convert.ToDateTime("0001-1-1 0:00:00")) { parameters[23].Value = "" + minYear + "-01-01 0:00:00"; } else { parameters[23].Value = model.UpdateTime; }
if (model.UpdateBy == null) { parameters[24].Value = ""; } else { parameters[24].Value = model.UpdateBy; }
if (model.UpdateIp == null) { parameters[25].Value = ""; } else { parameters[25].Value = model.UpdateIp; }
if (model.Re == null) { parameters[26].Value = ""; } else { parameters[26].Value = model.Re; }
if (model.IsPassed == null) { parameters[27].Value = ""; } else { parameters[27].Value = model.IsPassed; }
if (model.IsCheck == null) { parameters[28].Value = ""; } else { parameters[28].Value = model.IsCheck; }
if (model.SourceType == null) { parameters[29].Value = ""; } else { parameters[29].Value = model.SourceType; }
if (model.Nation == null) { parameters[30].Value = ""; } else { parameters[30].Value = model.Nation; }
parameters[31].Value = Guid.NewGuid(); int obj = db.ExecuteNonQuery(strSql.ToString(), parameters);
求解,求高手,求细心!!!
int obj = db.ExecuteNonQuery(strSql.ToString(), parameters);这个?估计跟你写的SQL语句参数定义的类型不同啊,string的转换不成数字
==============
检查一下String 数值是否包含字母或汉字(从数据库的数据表里看)比如,string aaa="123A",
这个aaa换到 Int32 肯定出错的