报错:
将截断字符串或二进制数据。
语句已终止。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 将截断字符串或二进制数据。
语句已终止。源错误:
行 239:
行 240:
行 241: int AddXSCase_result = CmdAddXSCase.ExecuteNonQuery();
行 242: con.Close();
行 243: if (AddXSCase_result == 1)
源文件: d:\hdfy\EntryClerk\EntryNewXSCase.aspx.cs 行: 241 以下是代码文件:
SqlConnection con = DB.Createconnection();
SqlCommand CmdAddXSCase = new SqlCommand();
CmdAddXSCase.CommandText = "Insert into XScase (XSCase_No,XSIndictment_No,XSCase_Reason,XSCaseKind_Value,XSCaseKind_Name,XSCaseSource,XSUnitCrime_Is,XSCommonCrime_Is,XS_CrimeGroup_Is,XSReferTriad_Is,XSReferDrag_Is,XSRefer_Gun_Is,XSMakeCase_Basis,XSReceiveCase_Date,XSMakeCase_Date,XS_Program_Value,XS_Program,XS_PlaintiffIncustody_Is,XS_Hd_Date,XS_Fd_Date,XS_TX_Date,XSCase_Plaintiff,XSPlaintiff_Add,XSCase_Defendant,XSDefendant_Add,XSNotpublicTrial_Is,XSNotpublicTrial_Reason,XSWithCivil_Is,XS_WithCivil_Claims,XSCase_Claims,XS_Self_Basis,XSCase_Abstracts,XSCaseMake_Money,XS_Receipt_No,XS_Reviewer_Suggestions,XS_Presedent_Opinion,XS_Entryor_Name,XS_Transfer_Date,XS_Transfer_Receiver,XS_Res,XS_Deal_Sended,XS_Deal_Sent_Asured,XS_Deal_ToStaff_Sented,XS_Deal_Staff_Accepted,XS_Deal_Is_finished,XS_Deal_Apply_Delay,XS_Deal_Delay_Allowed) ";
CmdAddXSCase.CommandText += "Values ('" + XSCase_No + "','";
CmdAddXSCase.CommandText += XSIndictment_No + "','";
CmdAddXSCase.CommandText += XSCase_Reason + "','";
CmdAddXSCase.CommandText += XSCaseKind_Value + "','";
CmdAddXSCase.CommandText += XSCaseKind_Name + "','";
CmdAddXSCase.CommandText += XSCaseSource + "','";
CmdAddXSCase.CommandText += XSUnitCrime_Is + "','";
CmdAddXSCase.CommandText += XSCommonCrime_Is + "','";//
CmdAddXSCase.CommandText += XS_CrimeGroup_Is + "','";
CmdAddXSCase.CommandText += XSReferTriad_Is + "','";
CmdAddXSCase.CommandText += XSReferDrag_Is + "','";
CmdAddXSCase.CommandText += XSRefer_Gun_Is + "','";
CmdAddXSCase.CommandText += XSMakeCase_Basis + "','";
CmdAddXSCase.CommandText += XSReceiveCase_Date + "','";
CmdAddXSCase.CommandText += XSMakeCase_Date + "','";
CmdAddXSCase.CommandText += XS_Program_Value + "','";
CmdAddXSCase.CommandText += XS_Program + "','";
CmdAddXSCase.CommandText += XS_PlaintiffIncustody_Is + "','";
CmdAddXSCase.CommandText += XS_Hd_Date + "','";
CmdAddXSCase.CommandText += XS_Fd_Date + "','";
CmdAddXSCase.CommandText += XS_TX_Date + "','";
CmdAddXSCase.CommandText += XSCase_Plaintiff + "','";
CmdAddXSCase.CommandText += XSPlaintiff_Add + "','";
CmdAddXSCase.CommandText += XSCase_Defendant + "','";
CmdAddXSCase.CommandText += XSDefendant_Add + "','";
CmdAddXSCase.CommandText += XSNotpublicTrial_Is + "','";
CmdAddXSCase.CommandText += XSNotpublicTrial_Reason + "','";
CmdAddXSCase.CommandText += XSWithCivil_Is + "','";
CmdAddXSCase.CommandText += XS_WithCivil_Claims+ "','";
CmdAddXSCase.CommandText += XSCase_Claims+ "','";
CmdAddXSCase.CommandText += XS_Self_Basis + "','";
CmdAddXSCase.CommandText += XSCase_Abstracts + "','";
CmdAddXSCase.CommandText += XSCaseMake_Money + "','";
CmdAddXSCase.CommandText += XS_Receipt_No + "','";
CmdAddXSCase.CommandText += XS_Reviewer_Suggestions + "','";
CmdAddXSCase.CommandText += XS_Presedent_Opinion + "','";
CmdAddXSCase.CommandText += XS_Entryor_Name + "','";
CmdAddXSCase.CommandText += XS_Transfer_Date + "','";
CmdAddXSCase.CommandText += XS_Transfer_Receiver + "','";
CmdAddXSCase.CommandText += XS_Res + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "')"; CmdAddXSCase.Connection = con;
int AddXSCase_result = CmdAddXSCase.ExecuteNonQuery();
con.Close();
if (AddXSCase_result == 1)
{ Response.Write("<script language='javascript'>alert('恭喜您,案件信息添加成功!');window.location.href('MSCaseInfo.aspx');</script>"); }
else
{
Response.Write("<script language='javascript'>alert('很抱歉,案件信息添加出现错误!请返回!');window.location.href('EntryNewMSCase.aspx');</script>"); }
将截断字符串或二进制数据。
语句已终止。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 将截断字符串或二进制数据。
语句已终止。源错误:
行 239:
行 240:
行 241: int AddXSCase_result = CmdAddXSCase.ExecuteNonQuery();
行 242: con.Close();
行 243: if (AddXSCase_result == 1)
源文件: d:\hdfy\EntryClerk\EntryNewXSCase.aspx.cs 行: 241 以下是代码文件:
SqlConnection con = DB.Createconnection();
SqlCommand CmdAddXSCase = new SqlCommand();
CmdAddXSCase.CommandText = "Insert into XScase (XSCase_No,XSIndictment_No,XSCase_Reason,XSCaseKind_Value,XSCaseKind_Name,XSCaseSource,XSUnitCrime_Is,XSCommonCrime_Is,XS_CrimeGroup_Is,XSReferTriad_Is,XSReferDrag_Is,XSRefer_Gun_Is,XSMakeCase_Basis,XSReceiveCase_Date,XSMakeCase_Date,XS_Program_Value,XS_Program,XS_PlaintiffIncustody_Is,XS_Hd_Date,XS_Fd_Date,XS_TX_Date,XSCase_Plaintiff,XSPlaintiff_Add,XSCase_Defendant,XSDefendant_Add,XSNotpublicTrial_Is,XSNotpublicTrial_Reason,XSWithCivil_Is,XS_WithCivil_Claims,XSCase_Claims,XS_Self_Basis,XSCase_Abstracts,XSCaseMake_Money,XS_Receipt_No,XS_Reviewer_Suggestions,XS_Presedent_Opinion,XS_Entryor_Name,XS_Transfer_Date,XS_Transfer_Receiver,XS_Res,XS_Deal_Sended,XS_Deal_Sent_Asured,XS_Deal_ToStaff_Sented,XS_Deal_Staff_Accepted,XS_Deal_Is_finished,XS_Deal_Apply_Delay,XS_Deal_Delay_Allowed) ";
CmdAddXSCase.CommandText += "Values ('" + XSCase_No + "','";
CmdAddXSCase.CommandText += XSIndictment_No + "','";
CmdAddXSCase.CommandText += XSCase_Reason + "','";
CmdAddXSCase.CommandText += XSCaseKind_Value + "','";
CmdAddXSCase.CommandText += XSCaseKind_Name + "','";
CmdAddXSCase.CommandText += XSCaseSource + "','";
CmdAddXSCase.CommandText += XSUnitCrime_Is + "','";
CmdAddXSCase.CommandText += XSCommonCrime_Is + "','";//
CmdAddXSCase.CommandText += XS_CrimeGroup_Is + "','";
CmdAddXSCase.CommandText += XSReferTriad_Is + "','";
CmdAddXSCase.CommandText += XSReferDrag_Is + "','";
CmdAddXSCase.CommandText += XSRefer_Gun_Is + "','";
CmdAddXSCase.CommandText += XSMakeCase_Basis + "','";
CmdAddXSCase.CommandText += XSReceiveCase_Date + "','";
CmdAddXSCase.CommandText += XSMakeCase_Date + "','";
CmdAddXSCase.CommandText += XS_Program_Value + "','";
CmdAddXSCase.CommandText += XS_Program + "','";
CmdAddXSCase.CommandText += XS_PlaintiffIncustody_Is + "','";
CmdAddXSCase.CommandText += XS_Hd_Date + "','";
CmdAddXSCase.CommandText += XS_Fd_Date + "','";
CmdAddXSCase.CommandText += XS_TX_Date + "','";
CmdAddXSCase.CommandText += XSCase_Plaintiff + "','";
CmdAddXSCase.CommandText += XSPlaintiff_Add + "','";
CmdAddXSCase.CommandText += XSCase_Defendant + "','";
CmdAddXSCase.CommandText += XSDefendant_Add + "','";
CmdAddXSCase.CommandText += XSNotpublicTrial_Is + "','";
CmdAddXSCase.CommandText += XSNotpublicTrial_Reason + "','";
CmdAddXSCase.CommandText += XSWithCivil_Is + "','";
CmdAddXSCase.CommandText += XS_WithCivil_Claims+ "','";
CmdAddXSCase.CommandText += XSCase_Claims+ "','";
CmdAddXSCase.CommandText += XS_Self_Basis + "','";
CmdAddXSCase.CommandText += XSCase_Abstracts + "','";
CmdAddXSCase.CommandText += XSCaseMake_Money + "','";
CmdAddXSCase.CommandText += XS_Receipt_No + "','";
CmdAddXSCase.CommandText += XS_Reviewer_Suggestions + "','";
CmdAddXSCase.CommandText += XS_Presedent_Opinion + "','";
CmdAddXSCase.CommandText += XS_Entryor_Name + "','";
CmdAddXSCase.CommandText += XS_Transfer_Date + "','";
CmdAddXSCase.CommandText += XS_Transfer_Receiver + "','";
CmdAddXSCase.CommandText += XS_Res + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "','";
CmdAddXSCase.CommandText += defaultstate + "')"; CmdAddXSCase.Connection = con;
int AddXSCase_result = CmdAddXSCase.ExecuteNonQuery();
con.Close();
if (AddXSCase_result == 1)
{ Response.Write("<script language='javascript'>alert('恭喜您,案件信息添加成功!');window.location.href('MSCaseInfo.aspx');</script>"); }
else
{
Response.Write("<script language='javascript'>alert('很抱歉,案件信息添加出现错误!请返回!');window.location.href('EntryNewMSCase.aspx');</script>"); }
你可以len(赋值的这个语句),看其长度.
CmdAddXSCase.CommandText += "Values ( ' " + XSCase_No + " ', ' ";
CmdAddXSCase.CommandText += XSIndictment_No + " ', ' ";
CmdAddXSCase.CommandText += XSCase_Reason + " ', ' ";
CmdAddXSCase.CommandText += XSCaseKind_Value + " ', ' ";
CmdAddXSCase.CommandText += XSCaseKind_Name + " ', ' ";
CmdAddXSCase.CommandText += XSCaseSource + " ', ' ";
CmdAddXSCase.CommandText += XSUnitCrime_Is + " ', ' ";
CmdAddXSCase.CommandText += XSCommonCrime_Is + " ', ' ";//
CmdAddXSCase.CommandText += XS_CrimeGroup_Is + " ', ' ";
CmdAddXSCase.CommandText += XSReferTriad_Is + " ', ' ";
CmdAddXSCase.CommandText += XSReferDrag_Is + " ', ' ";
CmdAddXSCase.CommandText += XSRefer_Gun_Is + " ', ' ";
CmdAddXSCase.CommandText += XSMakeCase_Basis + " ', ' ";
CmdAddXSCase.CommandText += XSReceiveCase_Date + " ', ' ";
CmdAddXSCase.CommandText += XSMakeCase_Date + " ', ' ";
CmdAddXSCase.CommandText += XS_Program_Value + " ', ' ";
CmdAddXSCase.CommandText += XS_Program + " ', ' ";
CmdAddXSCase.CommandText += XS_PlaintiffIncustody_Is + " ', ' ";
CmdAddXSCase.CommandText += XS_Hd_Date + " ', ' ";
CmdAddXSCase.CommandText += XS_Fd_Date + " ', ' ";
CmdAddXSCase.CommandText += XS_TX_Date + " ', ' ";
CmdAddXSCase.CommandText += XSCase_Plaintiff + " ', ' ";
CmdAddXSCase.CommandText += XSPlaintiff_Add + " ', ' ";
CmdAddXSCase.CommandText += XSCase_Defendant + " ', ' ";
CmdAddXSCase.CommandText += XSDefendant_Add + " ', ' ";
CmdAddXSCase.CommandText += XSNotpublicTrial_Is + " ', ' ";
CmdAddXSCase.CommandText += XSNotpublicTrial_Reason + " ', ' ";
CmdAddXSCase.CommandText += XSWithCivil_Is + " ', ' ";
CmdAddXSCase.CommandText += XS_WithCivil_Claims+ " ', ' ";
CmdAddXSCase.CommandText += XSCase_Claims+ " ', ' ";
CmdAddXSCase.CommandText += XS_Self_Basis + " ', ' ";
CmdAddXSCase.CommandText += XSCase_Abstracts + " ', ' ";
CmdAddXSCase.CommandText += XSCaseMake_Money + " ', ' ";
CmdAddXSCase.CommandText += XS_Receipt_No + " ', ' ";
CmdAddXSCase.CommandText += XS_Reviewer_Suggestions + " ', ' ";
CmdAddXSCase.CommandText += XS_Presedent_Opinion + " ', ' ";
CmdAddXSCase.CommandText += XS_Entryor_Name + " ', ' ";
CmdAddXSCase.CommandText += XS_Transfer_Date + " ', ' ";
CmdAddXSCase.CommandText += XS_Transfer_Receiver + " ', ' ";
CmdAddXSCase.CommandText += XS_Res + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ') ";
{
string XSCase_No = this.XSCase_No_TextBox.Text.Trim();//案号
string XSIndictment_No = this.Indictment_No_TextBox.Text.Trim();
string XSCase_Reason = this.XSCase_Reason_TextBox.Text;//案由
//string MS_Belong = this.DropDownList1.SelectedItem.Text.ToString();
string XSCaseKind_Value = this.DDL_Kind.SelectedValue.ToString();//案件种类 string XSCaseKind_Name = this.DDL_Kind.SelectedItem.Text.Trim().ToString();
int XSCaseSource = Convert.ToInt32(this.DDL_CaseSource.SelectedValue.ToString());//案件来源
int XSUnitCrime_Is; //单位犯罪
if (this.XS_UnitCrime_CheckBox.Checked)
{
XSUnitCrime_Is = 1;// student.StuSex = "1";
}
else
{
XSUnitCrime_Is = 0; //student.StuSex = "0";
}
int XSCommonCrime_Is; //共同犯罪
if (this.XS_CommonCrime_CheckBox.Checked)
{
XSCommonCrime_Is = 1;// student.StuSex = "1";
}
else
{
XSCommonCrime_Is = 0; //student.StuSex = "0";
}
int XS_CrimeGroup_Is; //集团犯罪
if (this.XS_CrimeGroupCheckBox.Checked)
{
XS_CrimeGroup_Is = 1;// student.StuSex = "1";
}
else
{
XS_CrimeGroup_Is = 0; //student.StuSex = "0";
}
int XSReferTriad_Is; //涉黑
if (this.ReferTriad_CheckBox.Checked)
{
XSReferTriad_Is = 1;// student.StuSex = "1";
}
else
{
XSReferTriad_Is = 0; //student.StuSex = "0";
}
int XSReferDrag_Is; //涉毒
if (this.ReferDrag_CheckBox.Checked)
{
XSReferDrag_Is = 1;// student.StuSex = "1";
}
else
{
XSReferDrag_Is = 0; //student.StuSex = "0";
}
int XSRefer_Gun_Is; //涉枪
if (this.Refer_GunCheckBox.Checked)
{
XSRefer_Gun_Is = 1;// student.StuSex = "1";
}
else
{
XSRefer_Gun_Is = 0; //student.StuSex = "0";
}
string XSMakeCase_Basis = this.XSMakeCase_Basis_TextBox.Text.Trim().ToString();//立案依据
System.DateTime XSReceiveCase_Date = this.XSReceiveCase_Date_Calendar.SelectedDate; //收案日期
System.DateTime XSMakeCase_Date = this.XSMakeCase_Date_Calendar.SelectedDate; //立案日期
string XS_Program_Value = this.Pro_DropDownList.SelectedValue.ToString();//MS_Program_Value//适用程序
string XS_Program = this.Pro_DropDownList.SelectedItem.Text.Trim().ToString();
int XS_PlaintiffIncustody_Is; //被告人是否被羁押
if (this.PlaintiffIncustody_CheckBox.Checked)
{
XS_PlaintiffIncustody_Is = 1;
}
else
{
XS_PlaintiffIncustody_Is = 0;
}
System.DateTime XS_Hd_Date;//衡东日期
System.DateTime XS_Fd_Date;//法定日期
System.DateTime XS_TX_Date;//提醒界限
if (this.Pro_DropDownList.SelectedValue == "JY")
{
XS_Hd_Date = XSMakeCase_Date.AddDays(20);
XS_Fd_Date = XSMakeCase_Date.AddDays(20);
XS_TX_Date = XS_Hd_Date.AddDays(-10); }
else
{
//if (XS_PlaintiffIncustody_Is==1)
//{
// XS_Hd_Date = XSMakeCase_Date.AddMonths(1);
// XS_Fd_Date = XSMakeCase_Date.AddMonths(1);
// XS_TX_Date = XS_Hd_Date.AddDays(-10);
//}
//else {
// XS_Hd_Date = XSMakeCase_Date.AddMonths(3);
// XS_Fd_Date = XSMakeCase_Date.AddMonths(6);
// XS_TX_Date = XS_Hd_Date.AddDays(-15);
// }
XS_Hd_Date = XSMakeCase_Date.AddMonths(3);
XS_Fd_Date = XSMakeCase_Date.AddMonths(6);
XS_TX_Date = XS_Hd_Date.AddDays(-15);
}
string XSCase_Plaintiff = this.XSCase_Plaintiff_TextBox.Text;
string XSPlaintiff_Add = this.XSPlaintiff_Add_TextBox.Text;
string XSCase_Defendant = this.XSCase_Defendant_TextBox.Text;
string XSDefendant_Add = this.XSDefendant_Add_TextBox.Text;
int XSNotpublicTrial_Is; //是否公开审判;
if (this.XS_NotpublicTrial_CheckBox.Checked)
{
XSNotpublicTrial_Is = 1;
}
else
{
XSNotpublicTrial_Is = 0;
}
string XSNotpublicTrial_Reason = this.XS_NotpublicTrialReason_TextBox.Text;
int XSWithCivil_Is;
if (this.XS_WithCivil_CheckBox.Checked)
{
XSWithCivil_Is = 1;
}
else
{
XSWithCivil_Is = 0; }
string XS_WithCivil_Claims = this.XS_WithCivilTarget_TextBox.Text; string XSCase_Claims = this.XSCase_Claims_TextBox.Text;//自诉请求
string XS_Self_Basis = this.XS_Self_Basis_TextBox.Text;//自诉的事实理由
string XSCase_Abstracts = this.XSCase_Abstracts_TextBox.Text;//案情摘要
string XSCaseMake_Money = this.XSCaseMake_Money_TextBox.Text;
string XS_Receipt_No = this.XS_Receipt_No_TextBox.Text;
string XS_Reviewer_Suggestions = this.XS_Reviewer_Suggestions_TextBox.Text;
string XS_Presedent_Opinion = this.XS_Presedent_Opinion_TextBox.Text;
string XS_Entryor_Name = this.XS_Entryor_Name_TextBox.Text;
string XS_Res = this.XS_Res_TextBox.Text;
System.DateTime XS_Transfer_Date = this.XS_Transfer_Date_Calendar.SelectedDate;
string XS_Transfer_Receiver=XS_Transfer_ReceiverTextBox.Text.Trim().ToString();
int defaultstate = 0;
求解!
求解!
求解!
CmdAddXSCase.CommandText += XSNotpublicTrial_Is + " ', ' ";
CmdAddXSCase.CommandText += XSNotpublicTrial_Reason + " ', ' ";
CmdAddXSCase.CommandText += XSWithCivil_Is + " ', ' ";
CmdAddXSCase.CommandText += XS_WithCivil_Claims+ " ', ' ";
CmdAddXSCase.CommandText += XSCase_Claims+ " ', ' ";
CmdAddXSCase.CommandText += XS_Self_Basis + " ', ' ";
CmdAddXSCase.CommandText += XSCase_Abstracts + " ', ' ";
CmdAddXSCase.CommandText += XSCaseMake_Money + " ', ' ";
CmdAddXSCase.CommandText += XS_Receipt_No + " ', ' ";
CmdAddXSCase.CommandText += XS_Reviewer_Suggestions + " ', ' ";
CmdAddXSCase.CommandText += XS_Presedent_Opinion + " ', ' ";
CmdAddXSCase.CommandText += XS_Entryor_Name + " ', ' ";
CmdAddXSCase.CommandText += XS_Transfer_Date + " ', ' ";
CmdAddXSCase.CommandText += XS_Transfer_Receiver + " ', ' ";
CmdAddXSCase.CommandText += XS_Res + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";
CmdAddXSCase.CommandText += defaultstate + " ', ' ";