/// <summary>
/// 给自定义控件赋值
/// </summary>
/// <param name="usercontrol"></param>
/// <param name="evi"></param>
private void setClueControlValue(CluePanel.UserControl1 usercontrol, Maticsoft.Model.caseinfo cainfo1)
{
usercontrol.Controls["lblClueNum"].Text = "" + cainfo1.caseNum;
usercontrol.Controls["label3"].Text = cainfo1.caseName;
usercontrol.Controls["label4"].Text = "" + cainfo1.threadType;
Maticsoft.Model.department depart1 = new Maticsoft.Model.department();
Maticsoft.BLL.department depart2 = new Maticsoft.BLL.department();
if (cainfo1.userPartment != null && !"".Equals(cainfo1.userPartment))
{
depart1 = depart2.GetModel(Convert.ToInt32(cainfo1.userPartment));
}
usercontrol.Controls["label5"].Text = depart1.departmentName;
usercontrol.Controls["label6"].Text = cainfo1.userName;
usercontrol.Controls["panel1"].Controls["label7"].Text = "" + cainfo1.id;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.caseinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,caseName,caseNum,userName,mainParty,createdTime,relatedCompany,relatedObject,trustee,inquireTime,status,remark,label,section,labels,department,sheng,shi,qu,caseType,acceptTime,allArea,allParent,whereFrom,threadType,suspectAddressID,threadSource,suspectPersonID,suspectUnitID,susItem,commitCrimeDate,disposal,crossNum,userRole,userID,userPartment,userSection,agreeStatus,substation,other,otherText,opinionInfo,fileUrl,fileName,isThread from caseinfo ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Maticsoft.Model.caseinfo model = new Maticsoft.Model.caseinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void showClue_d1(int pageIndex)
{
//获取数据
String searchContent = search_d1.Text;
String sql = "1=1";
if (isSearch_d1 && searchContent != null && !"".Equals(searchContent) && !"请输入要搜索的内容".Equals(searchContent) ||
isSearch_d1 && typeList_d1.Text != null && !"线索类型".Equals(typeList_d1.Text))
{
String type = typeList_d1.Text;
if (type.Equals("线索类型"))
{
type = "";
}
//if (type.Equals("电子邮件"))
// type = "" + (int)evType.E_Mail;
//if (type.Equals("综合文档"))
// type = "" + (int)evType.Integrated_document;
//if (type.Equals("图片资料"))
// type = "" + (int)evType.PicTure;
//if (type.Equals("电子话单"))
// type = "" + (int)evType.Electronic_statement;//or evType LIKE '%" + type + "%'
if (searchContent != null && !"".Equals(searchContent) && !"请输入要搜索的内容".Equals(searchContent))
{
sql = "threadType LIKE '%" + type + "%' and caseName LIKE '%" + searchContent + "%' or caseNum LIKE '%" + searchContent +
"%' or userName LIKE '%" + searchContent + "%'";
}
else
{
sql = "threadType LIKE '%" + type + "%'";
}
}
Maticsoft.BLL.caseinfo caseinfo1 = new Maticsoft.BLL.caseinfo();
DataSet ds = caseinfo1.GetList(sql + " limit " + (pageIndex - 1) * size_d1 + ",9");
// int count = evidence1.GetRecordCount("");
cluecount_d1 = caseinfo1.GetRecordCount(sql);//ds.Tables[0].Rows.Count;
List <Maticsoft.Model.caseinfo> listclue_d1 = new List <Maticsoft.Model.caseinfo>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Maticsoft.Model.caseinfo cainfo1 = new Maticsoft.Model.caseinfo();
cainfo1.id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString());
//evi.evName = ds.Tables[0].Rows[i]["evName"].ToString();
//evi.evType = Convert.ToInt32(ds.Tables[0].Rows[i]["evType"].ToString());
//evi.evAdmin = ds.Tables[0].Rows[i]["evAdmin"].ToString();
Maticsoft.Model.caseinfo cainfo = caseinfo1.GetModel(cainfo1.id);
listclue_d1.Add(cainfo);
}
//获取数据——end
//当前页该显示的线索条数
cluecount_now_d1 = 0;//初始为0
if (pageIndex * size_d1 <= cluecount_d1)
{
cluecount_now_d1 = 9;
}
else if ((pageIndex * size_d1 - size_d1) < cluecount_d1)
{
cluecount_now_d1 = cluecount_d1 % size_d1;
}
//显示每页的线索
if (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0)
{
clueitem9_d1.Visible = true;
setClueControlValue(clueitem9_d1, listclue_d1[8]);
}
if (cluecount_now_d1 % size_d1 >= 8 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem8_d1.Visible = true;
setClueControlValue(clueitem8_d1, listclue_d1[7]);
}
if (cluecount_now_d1 % size_d1 >= 7 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem7_d1.Visible = true;
setClueControlValue(clueitem7_d1, listclue_d1[6]);
}
if (cluecount_now_d1 % size_d1 >= 6 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem6_d1.Visible = true;
setClueControlValue(clueitem6_d1, listclue_d1[5]);
}
if (cluecount_now_d1 % size_d1 >= 5 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem5_d1.Visible = true;
setClueControlValue(clueitem5_d1, listclue_d1[4]);
}
if (cluecount_now_d1 % size_d1 >= 4 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem4_d1.Visible = true;
setClueControlValue(clueitem4_d1, listclue_d1[3]);
}
if (cluecount_now_d1 % size_d1 >= 3 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem3_d1.Visible = true;
setClueControlValue(clueitem3_d1, listclue_d1[2]);
}
if (cluecount_now_d1 % size_d1 >= 2 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem2_d1.Visible = true;
setClueControlValue(clueitem2_d1, listclue_d1[1]);
}
if (cluecount_now_d1 % size_d1 >= 1 || (cluecount_now_d1 % size_d1 == 0 && cluecount_now_d1 != 0))
{
clueitem1_d1.Visible = true;
setClueControlValue(clueitem1_d1, listclue_d1[0]);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.caseinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into caseinfo(");
strSql.Append("caseName,caseNum,userName,mainParty,createdTime,relatedCompany,relatedObject,trustee,inquireTime,status,remark,label,section,labels,department,sheng,shi,qu,caseType,acceptTime,allArea,allParent,whereFrom,threadType,suspectAddressID,threadSource,suspectPersonID,suspectUnitID,susItem,commitCrimeDate,disposal,crossNum,userRole,userID,userPartment,userSection,agreeStatus,substation,other,otherText,opinionInfo,fileUrl,fileName,isThread)");
strSql.Append(" values (");
strSql.Append("@caseName,@caseNum,@userName,@mainParty,@createdTime,@relatedCompany,@relatedObject,@trustee,@inquireTime,@status,@remark,@label,@section,@labels,@department,@sheng,@shi,@qu,@caseType,@acceptTime,@allArea,@allParent,@whereFrom,@threadType,@suspectAddressID,@threadSource,@suspectPersonID,@suspectUnitID,@susItem,@commitCrimeDate,@disposal,@crossNum,@userRole,@userID,@userPartment,@userSection,@agreeStatus,@substation,@other,@otherText,@opinionInfo,@fileUrl,@fileName,@isThread)");
MySqlParameter[] parameters =
{
new MySqlParameter("@caseName", MySqlDbType.VarChar, 100),
new MySqlParameter("@caseNum", MySqlDbType.VarChar, 100),
new MySqlParameter("@userName", MySqlDbType.VarChar, 100),
new MySqlParameter("@mainParty", MySqlDbType.VarChar, 100),
new MySqlParameter("@createdTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@relatedCompany", MySqlDbType.VarChar, 500),
new MySqlParameter("@relatedObject", MySqlDbType.VarChar, 500),
new MySqlParameter("@trustee", MySqlDbType.VarChar, 500),
new MySqlParameter("@inquireTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@status", MySqlDbType.VarChar, 100),
new MySqlParameter("@remark", MySqlDbType.VarChar, 500),
new MySqlParameter("@label", MySqlDbType.VarChar, 500),
new MySqlParameter("@section", MySqlDbType.VarChar, 200),
new MySqlParameter("@labels", MySqlDbType.VarChar, 255),
new MySqlParameter("@department", MySqlDbType.VarChar, 200),
new MySqlParameter("@sheng", MySqlDbType.VarChar, 255),
new MySqlParameter("@shi", MySqlDbType.VarChar, 255),
new MySqlParameter("@qu", MySqlDbType.VarChar, 255),
new MySqlParameter("@caseType", MySqlDbType.VarChar, 255),
new MySqlParameter("@acceptTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@allArea", MySqlDbType.VarChar, 255),
new MySqlParameter("@allParent", MySqlDbType.VarChar, 255),
new MySqlParameter("@whereFrom", MySqlDbType.VarChar, 255),
new MySqlParameter("@threadType", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectAddressID", MySqlDbType.VarChar, 255),
new MySqlParameter("@threadSource", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectPersonID", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectUnitID", MySqlDbType.VarChar, 255),
new MySqlParameter("@susItem", MySqlDbType.VarChar, 2000),
new MySqlParameter("@commitCrimeDate", MySqlDbType.VarChar, 255),
new MySqlParameter("@disposal", MySqlDbType.VarChar, 255),
new MySqlParameter("@crossNum", MySqlDbType.VarChar, 255),
new MySqlParameter("@userRole", MySqlDbType.VarChar, 255),
new MySqlParameter("@userID", MySqlDbType.VarChar, 255),
new MySqlParameter("@userPartment", MySqlDbType.VarChar, 255),
new MySqlParameter("@userSection", MySqlDbType.VarChar, 255),
new MySqlParameter("@agreeStatus", MySqlDbType.VarChar, 255),
new MySqlParameter("@substation", MySqlDbType.VarChar, 255),
new MySqlParameter("@other", MySqlDbType.VarChar, 255),
new MySqlParameter("@otherText", MySqlDbType.VarChar, 255),
new MySqlParameter("@opinionInfo", MySqlDbType.VarChar, 255),
new MySqlParameter("@fileUrl", MySqlDbType.VarChar, 255),
new MySqlParameter("@fileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@isThread", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.caseName;
parameters[1].Value = model.caseNum;
parameters[2].Value = model.userName;
parameters[3].Value = model.mainParty;
parameters[4].Value = model.createdTime;
parameters[5].Value = model.relatedCompany;
parameters[6].Value = model.relatedObject;
parameters[7].Value = model.trustee;
parameters[8].Value = model.inquireTime;
parameters[9].Value = model.status;
parameters[10].Value = model.remark;
parameters[11].Value = model.label;
parameters[12].Value = model.section;
parameters[13].Value = model.labels;
parameters[14].Value = model.department;
parameters[15].Value = model.sheng;
parameters[16].Value = model.shi;
parameters[17].Value = model.qu;
parameters[18].Value = model.caseType;
parameters[19].Value = model.acceptTime;
parameters[20].Value = model.allArea;
parameters[21].Value = model.allParent;
parameters[22].Value = model.whereFrom;
parameters[23].Value = model.threadType;
parameters[24].Value = model.suspectAddressID;
parameters[25].Value = model.threadSource;
parameters[26].Value = model.suspectPersonID;
parameters[27].Value = model.suspectUnitID;
parameters[28].Value = model.susItem;
parameters[29].Value = model.commitCrimeDate;
parameters[30].Value = model.disposal;
parameters[31].Value = model.crossNum;
parameters[32].Value = model.userRole;
parameters[33].Value = model.userID;
parameters[34].Value = model.userPartment;
parameters[35].Value = model.userSection;
parameters[36].Value = model.agreeStatus;
parameters[37].Value = model.substation;
parameters[38].Value = model.other;
parameters[39].Value = model.otherText;
parameters[40].Value = model.opinionInfo;
parameters[41].Value = model.fileUrl;
parameters[42].Value = model.fileName;
parameters[43].Value = model.isThread;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.caseinfo DataRowToModel(DataRow row)
{
Maticsoft.Model.caseinfo model = new Maticsoft.Model.caseinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["caseName"] != null)
{
model.caseName = row["caseName"].ToString();
}
if (row["caseNum"] != null)
{
model.caseNum = row["caseNum"].ToString();
}
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
if (row["mainParty"] != null)
{
model.mainParty = row["mainParty"].ToString();
}
if (row["createdTime"] != null)
{
model.createdTime = row["createdTime"].ToString();
}
if (row["relatedCompany"] != null)
{
model.relatedCompany = row["relatedCompany"].ToString();
}
if (row["relatedObject"] != null)
{
model.relatedObject = row["relatedObject"].ToString();
}
if (row["trustee"] != null)
{
model.trustee = row["trustee"].ToString();
}
if (row["inquireTime"] != null)
{
model.inquireTime = row["inquireTime"].ToString();
}
if (row["status"] != null)
{
model.status = row["status"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["label"] != null)
{
model.label = row["label"].ToString();
}
if (row["section"] != null)
{
model.section = row["section"].ToString();
}
if (row["labels"] != null)
{
model.labels = row["labels"].ToString();
}
if (row["department"] != null)
{
model.department = row["department"].ToString();
}
if (row["sheng"] != null)
{
model.sheng = row["sheng"].ToString();
}
if (row["shi"] != null)
{
model.shi = row["shi"].ToString();
}
if (row["qu"] != null)
{
model.qu = row["qu"].ToString();
}
if (row["caseType"] != null)
{
model.caseType = row["caseType"].ToString();
}
if (row["acceptTime"] != null)
{
model.acceptTime = row["acceptTime"].ToString();
}
if (row["allArea"] != null)
{
model.allArea = row["allArea"].ToString();
}
if (row["allParent"] != null)
{
model.allParent = row["allParent"].ToString();
}
if (row["whereFrom"] != null)
{
model.whereFrom = row["whereFrom"].ToString();
}
if (row["threadType"] != null)
{
model.threadType = row["threadType"].ToString();
}
if (row["suspectAddressID"] != null)
{
model.suspectAddressID = row["suspectAddressID"].ToString();
}
if (row["threadSource"] != null)
{
model.threadSource = row["threadSource"].ToString();
}
if (row["suspectPersonID"] != null)
{
model.suspectPersonID = row["suspectPersonID"].ToString();
}
if (row["suspectUnitID"] != null)
{
model.suspectUnitID = row["suspectUnitID"].ToString();
}
if (row["susItem"] != null)
{
model.susItem = row["susItem"].ToString();
}
if (row["commitCrimeDate"] != null)
{
model.commitCrimeDate = row["commitCrimeDate"].ToString();
}
if (row["disposal"] != null)
{
model.disposal = row["disposal"].ToString();
}
if (row["crossNum"] != null)
{
model.crossNum = row["crossNum"].ToString();
}
if (row["userRole"] != null)
{
model.userRole = row["userRole"].ToString();
}
if (row["userID"] != null)
{
model.userID = row["userID"].ToString();
}
if (row["userPartment"] != null)
{
model.userPartment = row["userPartment"].ToString();
}
if (row["userSection"] != null)
{
model.userSection = row["userSection"].ToString();
}
if (row["agreeStatus"] != null)
{
model.agreeStatus = row["agreeStatus"].ToString();
}
if (row["substation"] != null)
{
model.substation = row["substation"].ToString();
}
if (row["other"] != null)
{
model.other = row["other"].ToString();
}
if (row["otherText"] != null)
{
model.otherText = row["otherText"].ToString();
}
if (row["opinionInfo"] != null)
{
model.opinionInfo = row["opinionInfo"].ToString();
}
if (row["fileUrl"] != null)
{
model.fileUrl = row["fileUrl"].ToString();
}
if (row["fileName"] != null)
{
model.fileName = row["fileName"].ToString();
}
if (row["isThread"] != null)
{
model.isThread = row["isThread"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.caseinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update caseinfo set ");
strSql.Append("caseName=@caseName,");
strSql.Append("caseNum=@caseNum,");
strSql.Append("userName=@userName,");
strSql.Append("mainParty=@mainParty,");
strSql.Append("createdTime=@createdTime,");
strSql.Append("relatedCompany=@relatedCompany,");
strSql.Append("relatedObject=@relatedObject,");
strSql.Append("trustee=@trustee,");
strSql.Append("inquireTime=@inquireTime,");
strSql.Append("status=@status,");
strSql.Append("remark=@remark,");
strSql.Append("label=@label,");
strSql.Append("section=@section,");
strSql.Append("labels=@labels,");
strSql.Append("department=@department,");
strSql.Append("sheng=@sheng,");
strSql.Append("shi=@shi,");
strSql.Append("qu=@qu,");
strSql.Append("caseType=@caseType,");
strSql.Append("acceptTime=@acceptTime,");
strSql.Append("allArea=@allArea,");
strSql.Append("allParent=@allParent,");
strSql.Append("whereFrom=@whereFrom,");
strSql.Append("threadType=@threadType,");
strSql.Append("suspectAddressID=@suspectAddressID,");
strSql.Append("threadSource=@threadSource,");
strSql.Append("suspectPersonID=@suspectPersonID,");
strSql.Append("suspectUnitID=@suspectUnitID,");
strSql.Append("susItem=@susItem,");
strSql.Append("commitCrimeDate=@commitCrimeDate,");
strSql.Append("disposal=@disposal,");
strSql.Append("crossNum=@crossNum,");
strSql.Append("userRole=@userRole,");
strSql.Append("userID=@userID,");
strSql.Append("userPartment=@userPartment,");
strSql.Append("userSection=@userSection,");
strSql.Append("agreeStatus=@agreeStatus,");
strSql.Append("substation=@substation,");
strSql.Append("other=@other,");
strSql.Append("otherText=@otherText,");
strSql.Append("opinionInfo=@opinionInfo,");
strSql.Append("fileUrl=@fileUrl,");
strSql.Append("fileName=@fileName,");
strSql.Append("isThread=@isThread");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@caseName", MySqlDbType.VarChar, 100),
new MySqlParameter("@caseNum", MySqlDbType.VarChar, 100),
new MySqlParameter("@userName", MySqlDbType.VarChar, 100),
new MySqlParameter("@mainParty", MySqlDbType.VarChar, 100),
new MySqlParameter("@createdTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@relatedCompany", MySqlDbType.VarChar, 500),
new MySqlParameter("@relatedObject", MySqlDbType.VarChar, 500),
new MySqlParameter("@trustee", MySqlDbType.VarChar, 500),
new MySqlParameter("@inquireTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@status", MySqlDbType.VarChar, 100),
new MySqlParameter("@remark", MySqlDbType.VarChar, 500),
new MySqlParameter("@label", MySqlDbType.VarChar, 500),
new MySqlParameter("@section", MySqlDbType.VarChar, 200),
new MySqlParameter("@labels", MySqlDbType.VarChar, 255),
new MySqlParameter("@department", MySqlDbType.VarChar, 200),
new MySqlParameter("@sheng", MySqlDbType.VarChar, 255),
new MySqlParameter("@shi", MySqlDbType.VarChar, 255),
new MySqlParameter("@qu", MySqlDbType.VarChar, 255),
new MySqlParameter("@caseType", MySqlDbType.VarChar, 255),
new MySqlParameter("@acceptTime", MySqlDbType.VarChar, 100),
new MySqlParameter("@allArea", MySqlDbType.VarChar, 255),
new MySqlParameter("@allParent", MySqlDbType.VarChar, 255),
new MySqlParameter("@whereFrom", MySqlDbType.VarChar, 255),
new MySqlParameter("@threadType", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectAddressID", MySqlDbType.VarChar, 255),
new MySqlParameter("@threadSource", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectPersonID", MySqlDbType.VarChar, 255),
new MySqlParameter("@suspectUnitID", MySqlDbType.VarChar, 255),
new MySqlParameter("@susItem", MySqlDbType.VarChar, 2000),
new MySqlParameter("@commitCrimeDate", MySqlDbType.VarChar, 255),
new MySqlParameter("@disposal", MySqlDbType.VarChar, 255),
new MySqlParameter("@crossNum", MySqlDbType.VarChar, 255),
new MySqlParameter("@userRole", MySqlDbType.VarChar, 255),
new MySqlParameter("@userID", MySqlDbType.VarChar, 255),
new MySqlParameter("@userPartment", MySqlDbType.VarChar, 255),
new MySqlParameter("@userSection", MySqlDbType.VarChar, 255),
new MySqlParameter("@agreeStatus", MySqlDbType.VarChar, 255),
new MySqlParameter("@substation", MySqlDbType.VarChar, 255),
new MySqlParameter("@other", MySqlDbType.VarChar, 255),
new MySqlParameter("@otherText", MySqlDbType.VarChar, 255),
new MySqlParameter("@opinionInfo", MySqlDbType.VarChar, 255),
new MySqlParameter("@fileUrl", MySqlDbType.VarChar, 255),
new MySqlParameter("@fileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@isThread", MySqlDbType.VarChar, 20),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.caseName;
parameters[1].Value = model.caseNum;
parameters[2].Value = model.userName;
parameters[3].Value = model.mainParty;
parameters[4].Value = model.createdTime;
parameters[5].Value = model.relatedCompany;
parameters[6].Value = model.relatedObject;
parameters[7].Value = model.trustee;
parameters[8].Value = model.inquireTime;
parameters[9].Value = model.status;
parameters[10].Value = model.remark;
parameters[11].Value = model.label;
parameters[12].Value = model.section;
parameters[13].Value = model.labels;
parameters[14].Value = model.department;
parameters[15].Value = model.sheng;
parameters[16].Value = model.shi;
parameters[17].Value = model.qu;
parameters[18].Value = model.caseType;
parameters[19].Value = model.acceptTime;
parameters[20].Value = model.allArea;
parameters[21].Value = model.allParent;
parameters[22].Value = model.whereFrom;
parameters[23].Value = model.threadType;
parameters[24].Value = model.suspectAddressID;
parameters[25].Value = model.threadSource;
parameters[26].Value = model.suspectPersonID;
parameters[27].Value = model.suspectUnitID;
parameters[28].Value = model.susItem;
parameters[29].Value = model.commitCrimeDate;
parameters[30].Value = model.disposal;
parameters[31].Value = model.crossNum;
parameters[32].Value = model.userRole;
parameters[33].Value = model.userID;
parameters[34].Value = model.userPartment;
parameters[35].Value = model.userSection;
parameters[36].Value = model.agreeStatus;
parameters[37].Value = model.substation;
parameters[38].Value = model.other;
parameters[39].Value = model.otherText;
parameters[40].Value = model.opinionInfo;
parameters[41].Value = model.fileUrl;
parameters[42].Value = model.fileName;
parameters[43].Value = model.isThread;
parameters[44].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
