/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.LinkMans model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LinkMans set "); strSql.Append("CusID=@CusID,"); strSql.Append("LMName=@LMName,"); strSql.Append("LMSex=@LMSex,"); strSql.Append("LMDuty=@LMDuty,"); strSql.Append("LMMobileNo=@LMMobileNo,"); strSql.Append("LMOfficeNo=@LMOfficeNo,"); strSql.Append("LMMemo=@LMMemo"); strSql.Append(" where LMID=@LMID"); SqlParameter[] parameters = { new SqlParameter("@CusID", SqlDbType.Char, 14), new SqlParameter("@LMName", SqlDbType.NVarChar, 50), new SqlParameter("@LMSex", SqlDbType.Char, 2), new SqlParameter("@LMDuty", SqlDbType.NVarChar, 50), new SqlParameter("@LMMobileNo", SqlDbType.VarChar, 50), new SqlParameter("@LMOfficeNo", SqlDbType.VarChar, 50), new SqlParameter("@LMMemo", SqlDbType.NVarChar, 500), new SqlParameter("@LMID", SqlDbType.Int, 4) }; parameters[0].Value = model.CusID; parameters[1].Value = model.LMName; parameters[2].Value = model.LMSex; parameters[3].Value = model.LMDuty; parameters[4].Value = model.LMMobileNo; parameters[5].Value = model.LMOfficeNo; parameters[6].Value = model.LMMemo; parameters[7].Value = model.LMID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.LinkMans DataRowToModel(DataRow row) { Maticsoft.Model.LinkMans model = new Maticsoft.Model.LinkMans(); if (row != null) { if (row["LMID"] != null && row["LMID"].ToString() != "") { model.LMID = int.Parse(row["LMID"].ToString()); } if (row["CusID"] != null) { model.CusID = row["CusID"].ToString(); } if (row["LMName"] != null) { model.LMName = row["LMName"].ToString(); } if (row["LMSex"] != null) { model.LMSex = row["LMSex"].ToString(); } if (row["LMDuty"] != null) { model.LMDuty = row["LMDuty"].ToString(); } if (row["LMMobileNo"] != null) { model.LMMobileNo = row["LMMobileNo"].ToString(); } if (row["LMOfficeNo"] != null) { model.LMOfficeNo = row["LMOfficeNo"].ToString(); } if (row["LMMemo"] != null) { model.LMMemo = row["LMMemo"].ToString(); } if (row["CusName"] != null) { model.CusName = row["CusName"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.LinkMans model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LinkMans("); strSql.Append("CusID,LMName,LMSex,LMDuty,LMMobileNo,LMOfficeNo,LMMemo)"); strSql.Append(" values ("); strSql.Append("@CusID,@LMName,@LMSex,@LMDuty,@LMMobileNo,@LMOfficeNo,@LMMemo)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CusID", SqlDbType.Char, 14), new SqlParameter("@LMName", SqlDbType.NVarChar, 50), new SqlParameter("@LMSex", SqlDbType.Char, 2), new SqlParameter("@LMDuty", SqlDbType.NVarChar, 50), new SqlParameter("@LMMobileNo", SqlDbType.VarChar, 50), new SqlParameter("@LMOfficeNo", SqlDbType.VarChar, 50), new SqlParameter("@LMMemo", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.CusID; parameters[1].Value = model.LMName; parameters[2].Value = model.LMSex; parameters[3].Value = model.LMDuty; parameters[4].Value = model.LMMobileNo; parameters[5].Value = model.LMOfficeNo; parameters[6].Value = model.LMMemo; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.LinkMans GetModel(int LMID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LMID,CusID,LMName,LMSex,LMDuty,LMMobileNo,LMOfficeNo,LMMemo from LinkMans "); strSql.Append(" where LMID=@LMID"); SqlParameter[] parameters = { new SqlParameter("@LMID", SqlDbType.Int, 4) }; parameters[0].Value = LMID; Maticsoft.Model.LinkMans model = new Maticsoft.Model.LinkMans(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }