/// <summary> /// 增加一条数据 /// </summary> public int Add(XQCRSMSystem.Model.XQCR_CarRegister model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XQCR_CarRegister("); strSql.Append("ID,CommunityID,Community,SubdistrictID,Subdistrict,CarNumber,Name,Mobile,CreateUser,CreateDate,UpdateUser,UpdateDate,bak1,bak2,bak3,bak4,bak5"); strSql.Append(") values ("); strSql.Append("@ID,@CommunityID,@Community,@SubdistrictID,@Subdistrict,@CarNumber,@Name,@Mobile,@CreateUser,@CreateDate,@UpdateUser,@UpdateDate,@bak1,@bak2,@bak3,@bak4,@bak5"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 50), new SqlParameter("@CommunityID", SqlDbType.NVarChar, 50), new SqlParameter("@Community", SqlDbType.NVarChar, 50), new SqlParameter("@SubdistrictID", SqlDbType.NVarChar, 50), new SqlParameter("@Subdistrict", SqlDbType.NVarChar, 50), new SqlParameter("@CarNumber", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Mobile", SqlDbType.NVarChar, 50), new SqlParameter("@CreateUser", SqlDbType.NVarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.NVarChar, 50), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@bak1", SqlDbType.NVarChar, 200), new SqlParameter("@bak2", SqlDbType.NVarChar, 200), new SqlParameter("@bak3", SqlDbType.NVarChar, 200), new SqlParameter("@bak4", SqlDbType.NVarChar, 200), new SqlParameter("@bak5", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.CommunityID; parameters[2].Value = model.Community; parameters[3].Value = model.SubdistrictID; parameters[4].Value = model.Subdistrict; parameters[5].Value = model.CarNumber; parameters[6].Value = model.Name; parameters[7].Value = model.Mobile; parameters[8].Value = model.CreateUser; parameters[9].Value = model.CreateDate; parameters[10].Value = model.UpdateUser; parameters[11].Value = model.UpdateDate; parameters[12].Value = model.bak1; parameters[13].Value = model.bak2; parameters[14].Value = model.bak3; parameters[15].Value = model.bak4; parameters[16].Value = model.bak5; int i = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return(i); }
/// <summary> /// 得到一个对象实体 /// </summary> public XQCRSMSystem.Model.XQCR_CarRegister GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, CommunityID, Community, SubdistrictID, Subdistrict, CarNumber, Name, Mobile, CreateUser, CreateDate, UpdateUser, UpdateDate, bak1, bak2, bak3, bak4, bak5 "); strSql.Append(" from XQCR_CarRegister "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 50) }; parameters[0].Value = ID; XQCRSMSystem.Model.XQCR_CarRegister model = new XQCRSMSystem.Model.XQCR_CarRegister(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ID = ds.Tables[0].Rows[0]["ID"].ToString(); model.CommunityID = ds.Tables[0].Rows[0]["CommunityID"].ToString(); model.Community = ds.Tables[0].Rows[0]["Community"].ToString(); model.SubdistrictID = ds.Tables[0].Rows[0]["SubdistrictID"].ToString(); model.Subdistrict = ds.Tables[0].Rows[0]["Subdistrict"].ToString(); model.CarNumber = ds.Tables[0].Rows[0]["CarNumber"].ToString(); model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.CreateUser = ds.Tables[0].Rows[0]["CreateUser"].ToString(); if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } model.UpdateUser = ds.Tables[0].Rows[0]["UpdateUser"].ToString(); if (ds.Tables[0].Rows[0]["UpdateDate"].ToString() != "") { model.UpdateDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateDate"].ToString()); } model.bak1 = ds.Tables[0].Rows[0]["bak1"].ToString(); model.bak2 = ds.Tables[0].Rows[0]["bak2"].ToString(); model.bak3 = ds.Tables[0].Rows[0]["bak3"].ToString(); model.bak4 = ds.Tables[0].Rows[0]["bak4"].ToString(); model.bak5 = ds.Tables[0].Rows[0]["bak5"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XQCRSMSystem.Model.XQCR_CarRegister model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XQCR_CarRegister set "); strSql.Append(" ID = @ID , "); strSql.Append(" CommunityID = @CommunityID , "); strSql.Append(" Community = @Community , "); strSql.Append(" SubdistrictID = @SubdistrictID , "); strSql.Append(" Subdistrict = @Subdistrict , "); strSql.Append(" CarNumber = @CarNumber , "); strSql.Append(" Name = @Name , "); strSql.Append(" Mobile = @Mobile , "); strSql.Append(" CreateUser = @CreateUser , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" UpdateUser = @UpdateUser , "); strSql.Append(" UpdateDate = @UpdateDate , "); strSql.Append(" bak1 = @bak1 , "); strSql.Append(" bak2 = @bak2 , "); strSql.Append(" bak3 = @bak3 , "); strSql.Append(" bak4 = @bak4 , "); strSql.Append(" bak5 = @bak5 "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 50), new SqlParameter("@CommunityID", SqlDbType.NVarChar, 50), new SqlParameter("@Community", SqlDbType.NVarChar, 50), new SqlParameter("@SubdistrictID", SqlDbType.NVarChar, 50), new SqlParameter("@Subdistrict", SqlDbType.NVarChar, 50), new SqlParameter("@CarNumber", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Mobile", SqlDbType.NVarChar, 50), new SqlParameter("@CreateUser", SqlDbType.NVarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.NVarChar, 50), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@bak1", SqlDbType.NVarChar, 200), new SqlParameter("@bak2", SqlDbType.NVarChar, 200), new SqlParameter("@bak3", SqlDbType.NVarChar, 200), new SqlParameter("@bak4", SqlDbType.NVarChar, 200), new SqlParameter("@bak5", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.CommunityID; parameters[2].Value = model.Community; parameters[3].Value = model.SubdistrictID; parameters[4].Value = model.Subdistrict; parameters[5].Value = model.CarNumber; parameters[6].Value = model.Name; parameters[7].Value = model.Mobile; parameters[8].Value = model.CreateUser; parameters[9].Value = model.CreateDate; parameters[10].Value = model.UpdateUser; parameters[11].Value = model.UpdateDate; parameters[12].Value = model.bak1; parameters[13].Value = model.bak2; parameters[14].Value = model.bak3; parameters[15].Value = model.bak4; parameters[16].Value = model.bak5; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }