/// <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); } }