/// <summary> /// 更新一条数据 /// </summary> public bool Update(UserFB.Model.ApplyMessage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ApplyMessage set "); strSql.Append("applicantID=@applicantID,"); strSql.Append("approverID=@approverID,"); strSql.Append("name=@name,"); strSql.Append("department=@department,"); strSql.Append("job=@job,"); strSql.Append("permission=@permission,"); strSql.Append("applyTime=@applyTime,"); strSql.Append("applyState=@applyState,"); strSql.Append("remark=@remark"); strSql.Append(" where ApplyID=@ApplyID"); SqlParameter[] parameters = { new SqlParameter("@applicantID", SqlDbType.Int, 4), new SqlParameter("@approverID", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 64), new SqlParameter("@department", SqlDbType.VarChar, 64), new SqlParameter("@job", SqlDbType.VarChar, 64), new SqlParameter("@permission", SqlDbType.VarChar, 16), new SqlParameter("@applyTime", SqlDbType.SmallDateTime), new SqlParameter("@applyState", SqlDbType.VarChar, 16), new SqlParameter("@remark", SqlDbType.VarChar, 64), new SqlParameter("@ApplyID", SqlDbType.Int, 4) }; parameters[0].Value = model.applicantID; parameters[1].Value = model.approverID; parameters[2].Value = model.name; parameters[3].Value = model.department; parameters[4].Value = model.job; parameters[5].Value = model.permission; parameters[6].Value = model.applyTime; parameters[7].Value = model.applyState; parameters[8].Value = model.remark; parameters[9].Value = model.ApplyID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public UserFB.Model.ApplyMessage DataRowToModel(DataRow row) { UserFB.Model.ApplyMessage model = new UserFB.Model.ApplyMessage(); if (row != null) { if (row["ApplyID"] != null && row["ApplyID"].ToString() != "") { model.ApplyID = int.Parse(row["ApplyID"].ToString()); } if (row["applicantID"] != null && row["applicantID"].ToString() != "") { model.applicantID = int.Parse(row["applicantID"].ToString()); } if (row["approverID"] != null && row["approverID"].ToString() != "") { model.approverID = int.Parse(row["approverID"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["department"] != null) { model.department = row["department"].ToString(); } if (row["job"] != null) { model.job = row["job"].ToString(); } if (row["permission"] != null) { model.permission = row["permission"].ToString(); } if (row["applyTime"] != null && row["applyTime"].ToString() != "") { model.applyTime = DateTime.Parse(row["applyTime"].ToString()); } if (row["applyState"] != null) { model.applyState = row["applyState"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(UserFB.Model.ApplyMessage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ApplyMessage("); strSql.Append("applicantID,approverID,name,department,job,permission,applyTime,applyState,remark)"); strSql.Append(" values ("); strSql.Append("@applicantID,@approverID,@name,@department,@job,@permission,@applyTime,@applyState,@remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@applicantID", SqlDbType.Int, 4), new SqlParameter("@approverID", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 64), new SqlParameter("@department", SqlDbType.VarChar, 64), new SqlParameter("@job", SqlDbType.VarChar, 64), new SqlParameter("@permission", SqlDbType.VarChar, 16), new SqlParameter("@applyTime", SqlDbType.SmallDateTime), new SqlParameter("@applyState", SqlDbType.VarChar, 16), new SqlParameter("@remark", SqlDbType.VarChar, 64) }; parameters[0].Value = model.applicantID; parameters[1].Value = model.approverID; parameters[2].Value = model.name; parameters[3].Value = model.department; parameters[4].Value = model.job; parameters[5].Value = model.permission; parameters[6].Value = model.applyTime; parameters[7].Value = model.applyState; parameters[8].Value = model.remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(false); } else { return(true); } }
/// <summary> /// 得到一个对象实体 /// </summary> public UserFB.Model.ApplyMessage GetModel(int ApplyID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ApplyID,applicantID,approverID,name,department,job,permission,applyTime,applyState,remark from ApplyMessage "); strSql.Append(" where ApplyID=@ApplyID"); SqlParameter[] parameters = { new SqlParameter("@ApplyID", SqlDbType.Int, 4) }; parameters[0].Value = ApplyID; UserFB.Model.ApplyMessage model = new UserFB.Model.ApplyMessage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }