/// <summary> /// 增加一条数据 /// </summary> public int Insert(Model.T_Ushield model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [T_Ushield]("); strSql.Append("UName,HardWareCode,Seed,UKey,Remark,DeleteMark"); strSql.Append(") values ("); strSql.Append("@UName,@HardWareCode,@Seed,@UKey,@Remark,@DeleteMark"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UName", SqlDbType.VarChar, 100), new SqlParameter("@HardWareCode", SqlDbType.VarChar, 100), new SqlParameter("@Seed", SqlDbType.VarChar, 100), new SqlParameter("@UKey", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@DeleteMark", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.UName; parameters[1].Value = model.HardWareCode; parameters[2].Value = model.Seed; parameters[3].Value = model.UKey; parameters[4].Value = model.Remark; parameters[5].Value = model.DeleteMark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.T_Ushield model) { StringBuilder strSql = new StringBuilder(); Collection <SqlParameter> parameters = new Collection <SqlParameter> (); SqlParameter parameter = null; int count = 0; strSql.Append("update [T_Ushield] set "); parameter = new SqlParameter("@ID", SqlDbType.Int, 4); parameter.Value = model.ID; parameters.Add(parameter); if (model.UName_IsEdit) { strSql.Append(" UName = @UName,"); parameter = new SqlParameter("@UName", SqlDbType.VarChar, 100); parameter.Value = model.UName; parameters.Add(parameter); count++; } if (model.HardWareCode_IsEdit) { strSql.Append(" HardWareCode = @HardWareCode,"); parameter = new SqlParameter("@HardWareCode", SqlDbType.VarChar, 100); parameter.Value = model.HardWareCode; parameters.Add(parameter); count++; } if (model.Seed_IsEdit) { strSql.Append(" Seed = @Seed,"); parameter = new SqlParameter("@Seed", SqlDbType.VarChar, 100); parameter.Value = model.Seed; parameters.Add(parameter); count++; } if (model.UKey_IsEdit) { strSql.Append(" UKey = @UKey,"); parameter = new SqlParameter("@UKey", SqlDbType.VarChar, 100); parameter.Value = model.UKey; parameters.Add(parameter); count++; } if (model.Remark_IsEdit) { strSql.Append(" Remark = @Remark,"); parameter = new SqlParameter("@Remark", SqlDbType.VarChar, 200); parameter.Value = model.Remark; parameters.Add(parameter); count++; } if (model.DeleteMark_IsEdit) { strSql.Append(" DeleteMark = @DeleteMark,"); parameter = new SqlParameter("@DeleteMark", SqlDbType.TinyInt, 1); parameter.Value = model.DeleteMark; parameters.Add(parameter); count++; } if (count > 0) { strSql.Remove(strSql.Length - 1, 1); } if (count == 0) { return(false); } strSql.Append(" where ID=@ID "); // 将参数泛形集合转传为数组 SqlParameter[] args = new SqlParameter[parameters.Count]; parameters.CopyTo(args, 0); int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), args); if (rows > 0) { return(true); } else { return(false); } }