/// <summary> /// 更新一条数据 /// </summary> public bool Update(ML.Model.S_Dictionary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update S_Dictionary set "); strSql.Append("PID=@PID,"); strSql.Append("DicType=@DicType,"); strSql.Append("DicKey=@DicKey,"); strSql.Append("DicValue=@DicValue,"); strSql.Append("Remark=@Remark,"); strSql.Append("Seq=@Seq"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@PID", SqlDbType.VarChar, 50), new SqlParameter("@DicType", SqlDbType.NVarChar, 50), new SqlParameter("@DicKey", SqlDbType.NVarChar, 50), new SqlParameter("@DicValue", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@Seq", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.PID; parameters[1].Value = model.DicType; parameters[2].Value = model.DicKey; parameters[3].Value = model.DicValue; parameters[4].Value = model.Remark; parameters[5].Value = model.Seq; parameters[6].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ML.Model.S_Dictionary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into S_Dictionary("); strSql.Append("ID,PID,DicType,DicKey,DicValue,Remark,Seq)"); strSql.Append(" values ("); strSql.Append("@ID,@PID,@DicType,@DicKey,@DicValue,@Remark,@Seq)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50), new SqlParameter("@PID", SqlDbType.VarChar, 50), new SqlParameter("@DicType", SqlDbType.NVarChar, 50), new SqlParameter("@DicKey", SqlDbType.NVarChar, 50), new SqlParameter("@DicValue", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@Seq", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.PID; parameters[2].Value = model.DicType; parameters[3].Value = model.DicKey; parameters[4].Value = model.DicValue; parameters[5].Value = model.Remark; parameters[6].Value = model.Seq; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ML.Model.S_Dictionary DataRowToModel(DataRow row) { ML.Model.S_Dictionary model = new ML.Model.S_Dictionary(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["PID"] != null) { model.PID = row["PID"].ToString(); } if (row["DicType"] != null) { model.DicType = row["DicType"].ToString(); } if (row["DicKey"] != null) { model.DicKey = row["DicKey"].ToString(); } if (row["DicValue"] != null) { model.DicValue = row["DicValue"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["Seq"] != null && row["Seq"].ToString() != "") { model.Seq = int.Parse(row["Seq"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ML.Model.S_Dictionary GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,PID,DicType,DicKey,DicValue,Remark,Seq from S_Dictionary "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50) }; parameters[0].Value = ID; ML.Model.S_Dictionary model = new ML.Model.S_Dictionary(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }