/// <summary> /// 更新一条数据 /// </summary> public bool Update(Scheme_DynamicParameterList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Scheme_DynamicParameterList set "); strSql.Append(" chrParaName = @chrParaName , "); strSql.Append(" chrParaDetail = @chrParaDetail , "); strSql.Append(" chrGrpType = @chrGrpType , "); strSql.Append(" intItemTypeOrPrjNo = @intItemTypeOrPrjNo , "); strSql.Append(" chrControlType = @chrControlType , "); strSql.Append(" chrDefValue = @chrDefValue , "); strSql.Append(" chrVisiable = @chrVisiable , "); strSql.Append(" chrStatus = @chrStatus , "); strSql.Append(" chrGlobalPara = @chrGlobalPara , "); strSql.Append(" ChangeDate = @ChangeDate , "); strSql.Append(" chrEditor = @chrEditor "); strSql.Append(" where schemeID=@schemeID "); OleDbParameter[] parameters = { new OleDbParameter("@schemeID", OleDbType.Integer, 4), new OleDbParameter("@chrParaName", OleDbType.VarChar, 50), new OleDbParameter("@chrParaDetail", OleDbType.VarChar, 200), new OleDbParameter("@chrGrpType", OleDbType.VarChar, 8), new OleDbParameter("@intItemTypeOrPrjNo", OleDbType.Integer, 4), new OleDbParameter("@chrControlType", OleDbType.VarChar, 1), new OleDbParameter("@chrDefValue", OleDbType.VarChar, 255), new OleDbParameter("@chrVisiable", OleDbType.VarChar, 20), new OleDbParameter("@chrStatus", OleDbType.VarChar, 20), new OleDbParameter("@chrGlobalPara", OleDbType.VarChar, 20), new OleDbParameter("@ChangeDate", OleDbType.Date), new OleDbParameter("@chrEditor", OleDbType.VarChar, 10) }; parameters[11].Value = model.schemeID; parameters[12].Value = model.chrParaName; parameters[13].Value = model.chrParaDetail; parameters[14].Value = model.chrGrpType; parameters[15].Value = model.intItemTypeOrPrjNo; parameters[16].Value = model.chrControlType; parameters[17].Value = model.chrDefValue; parameters[18].Value = model.chrVisiable; parameters[19].Value = model.chrStatus; parameters[20].Value = model.chrGlobalPara; parameters[21].Value = model.ChangeDate; parameters[22].Value = model.chrEditor; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Scheme_DynamicParameterList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Scheme_DynamicParameterList("); strSql.Append("chrParaName,chrParaDetail,chrGrpType,intItemTypeOrPrjNo,chrControlType,chrDefValue,chrVisiable,chrStatus,chrGlobalPara,ChangeDate,chrEditor"); strSql.Append(") values ("); strSql.Append("@chrParaName,@chrParaDetail,@chrGrpType,@intItemTypeOrPrjNo,@chrControlType,@chrDefValue,@chrVisiable,@chrStatus,@chrGlobalPara,@ChangeDate,@chrEditor"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); OleDbParameter[] parameters = { new OleDbParameter("@chrParaName", OleDbType.VarChar, 50), new OleDbParameter("@chrParaDetail", OleDbType.VarChar, 200), new OleDbParameter("@chrGrpType", OleDbType.VarChar, 8), new OleDbParameter("@intItemTypeOrPrjNo", OleDbType.Integer, 4), new OleDbParameter("@chrControlType", OleDbType.VarChar, 1), new OleDbParameter("@chrDefValue", OleDbType.VarChar, 255), new OleDbParameter("@chrVisiable", OleDbType.VarChar, 20), new OleDbParameter("@chrStatus", OleDbType.VarChar, 20), new OleDbParameter("@chrGlobalPara", OleDbType.VarChar, 20), new OleDbParameter("@ChangeDate", OleDbType.Date), new OleDbParameter("@chrEditor", OleDbType.VarChar, 10) }; parameters[0].Value = model.chrParaName; parameters[1].Value = model.chrParaDetail; parameters[2].Value = model.chrGrpType; parameters[3].Value = model.intItemTypeOrPrjNo; parameters[4].Value = model.chrControlType; parameters[5].Value = model.chrDefValue; parameters[6].Value = model.chrVisiable; parameters[7].Value = model.chrStatus; parameters[8].Value = model.chrGlobalPara; parameters[9].Value = model.ChangeDate; parameters[10].Value = model.chrEditor; object obj = DbHelperOleDb.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scheme_DynamicParameterList GetModel(int schemeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select schemeID, chrParaName, chrParaDetail, chrGrpType, intItemTypeOrPrjNo, chrControlType, chrDefValue, chrVisiable, chrStatus, chrGlobalPara, ChangeDate, chrEditor "); strSql.Append(" from Scheme_DynamicParameterList "); strSql.Append(" where schemeID=@schemeID"); OleDbParameter[] parameters = { new OleDbParameter("@schemeID", OleDbType.Integer, 4) }; parameters[0].Value = schemeID; Scheme_DynamicParameterList model = new Scheme_DynamicParameterList(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["schemeID"].ToString() != "") { model.schemeID = int.Parse(ds.Tables[0].Rows[0]["schemeID"].ToString()); } model.chrParaName = ds.Tables[0].Rows[0]["chrParaName"].ToString(); model.chrParaDetail = ds.Tables[0].Rows[0]["chrParaDetail"].ToString(); model.chrGrpType = ds.Tables[0].Rows[0]["chrGrpType"].ToString(); if (ds.Tables[0].Rows[0]["intItemTypeOrPrjNo"].ToString() != "") { model.intItemTypeOrPrjNo = int.Parse(ds.Tables[0].Rows[0]["intItemTypeOrPrjNo"].ToString()); } model.chrControlType = ds.Tables[0].Rows[0]["chrControlType"].ToString(); model.chrDefValue = ds.Tables[0].Rows[0]["chrDefValue"].ToString(); model.chrVisiable = ds.Tables[0].Rows[0]["chrVisiable"].ToString(); model.chrStatus = ds.Tables[0].Rows[0]["chrStatus"].ToString(); model.chrGlobalPara = ds.Tables[0].Rows[0]["chrGlobalPara"].ToString(); if (ds.Tables[0].Rows[0]["ChangeDate"].ToString() != "") { model.ChangeDate = DateTime.Parse(ds.Tables[0].Rows[0]["ChangeDate"].ToString()); } model.chrEditor = ds.Tables[0].Rows[0]["chrEditor"].ToString(); return(model); } else { return(null); } }
/// <summary> /// Scheme_DynamicParameterList 修改SQL语句,不支持并发修改使用 /// </summary> public string UpdateSQL(Scheme_DynamicParameterList Scheme_DynamicParameterList, string strWhere) { if (string.IsNullOrEmpty(strWhere)) { strWhere = "1=1"; } string setValues = ""; if (Scheme_DynamicParameterList.schemeID.ToString().Trim() != "") { setValues += "schemeID='" + Scheme_DynamicParameterList.schemeID + "',"; } if (Scheme_DynamicParameterList.chrParaName != null && Scheme_DynamicParameterList.chrParaName.ToString().Trim() != "") { setValues += "chrParaName='" + Scheme_DynamicParameterList.chrParaName + "',"; } if (Scheme_DynamicParameterList.chrParaDetail != null && Scheme_DynamicParameterList.chrParaDetail.ToString().Trim() != "") { setValues += "chrParaDetail='" + Scheme_DynamicParameterList.chrParaDetail + "',"; } if (Scheme_DynamicParameterList.chrGrpType != null && Scheme_DynamicParameterList.chrGrpType.ToString().Trim() != "") { setValues += "chrGrpType='" + Scheme_DynamicParameterList.chrGrpType + "',"; } if (Scheme_DynamicParameterList.intItemTypeOrPrjNo.ToString().Trim() != "") { setValues += "intItemTypeOrPrjNo='" + Scheme_DynamicParameterList.intItemTypeOrPrjNo + "',"; } if (Scheme_DynamicParameterList.chrControlType != null && Scheme_DynamicParameterList.chrControlType.ToString().Trim() != "") { setValues += "chrControlType='" + Scheme_DynamicParameterList.chrControlType + "',"; } if (Scheme_DynamicParameterList.chrDefValue != null && Scheme_DynamicParameterList.chrDefValue.ToString().Trim() != "") { setValues += "chrDefValue='" + Scheme_DynamicParameterList.chrDefValue + "',"; } if (Scheme_DynamicParameterList.chrVisiable != null && Scheme_DynamicParameterList.chrVisiable.ToString().Trim() != "") { setValues += "chrVisiable='" + Scheme_DynamicParameterList.chrVisiable + "',"; } if (Scheme_DynamicParameterList.chrStatus != null && Scheme_DynamicParameterList.chrStatus.ToString().Trim() != "") { setValues += "chrStatus='" + Scheme_DynamicParameterList.chrStatus + "',"; } if (Scheme_DynamicParameterList.chrGlobalPara != null && Scheme_DynamicParameterList.chrGlobalPara.ToString().Trim() != "") { setValues += "chrGlobalPara='" + Scheme_DynamicParameterList.chrGlobalPara + "',"; } if (Scheme_DynamicParameterList.ChangeDate != null && Scheme_DynamicParameterList.ChangeDate.ToString().Trim() != "") { setValues += "ChangeDate='" + Scheme_DynamicParameterList.ChangeDate + "',"; } if (Scheme_DynamicParameterList.chrEditor != null && Scheme_DynamicParameterList.chrEditor.ToString().Trim() != "") { setValues += "chrEditor='" + Scheme_DynamicParameterList.chrEditor + "',"; } setValues = setValues.Substring(0, setValues.Length - 1); string _SqlText = ""; if (!string.IsNullOrEmpty(setValues)) { _SqlText = string.Format("update {0} set {1} where {2} ", "Scheme_DynamicParameterList", setValues, strWhere); } return(_SqlText); }
/// <summary> /// Scheme_DynamicParameterList 插入SQL语句 /// </summary> public string InsertSQL(Scheme_DynamicParameterList Scheme_DynamicParameterList) { string strColumns = ""; string strValues = ""; if (Scheme_DynamicParameterList.schemeID.ToString().Trim() != "") { strColumns += "schemeID,"; strValues += "'" + Scheme_DynamicParameterList.schemeID + "',"; } if (Scheme_DynamicParameterList.chrParaName != null && Scheme_DynamicParameterList.chrParaName.ToString().Trim() != "") { strColumns += "chrParaName,"; strValues += "'" + Scheme_DynamicParameterList.chrParaName + "',"; } if (Scheme_DynamicParameterList.chrParaDetail != null && Scheme_DynamicParameterList.chrParaDetail.ToString().Trim() != "") { strColumns += "chrParaDetail,"; strValues += "'" + Scheme_DynamicParameterList.chrParaDetail + "',"; } if (Scheme_DynamicParameterList.chrGrpType != null && Scheme_DynamicParameterList.chrGrpType.ToString().Trim() != "") { strColumns += "chrGrpType,"; strValues += "'" + Scheme_DynamicParameterList.chrGrpType + "',"; } if (Scheme_DynamicParameterList.intItemTypeOrPrjNo.ToString().Trim() != "") { strColumns += "intItemTypeOrPrjNo,"; strValues += "'" + Scheme_DynamicParameterList.intItemTypeOrPrjNo + "',"; } if (Scheme_DynamicParameterList.chrControlType != null && Scheme_DynamicParameterList.chrControlType.ToString().Trim() != "") { strColumns += "chrControlType,"; strValues += "'" + Scheme_DynamicParameterList.chrControlType + "',"; } if (Scheme_DynamicParameterList.chrDefValue != null && Scheme_DynamicParameterList.chrDefValue.ToString().Trim() != "") { strColumns += "chrDefValue,"; strValues += "'" + Scheme_DynamicParameterList.chrDefValue + "',"; } if (Scheme_DynamicParameterList.chrVisiable != null && Scheme_DynamicParameterList.chrVisiable.ToString().Trim() != "") { strColumns += "chrVisiable,"; strValues += "'" + Scheme_DynamicParameterList.chrVisiable + "',"; } if (Scheme_DynamicParameterList.chrStatus != null && Scheme_DynamicParameterList.chrStatus.ToString().Trim() != "") { strColumns += "chrStatus,"; strValues += "'" + Scheme_DynamicParameterList.chrStatus + "',"; } if (Scheme_DynamicParameterList.chrGlobalPara != null && Scheme_DynamicParameterList.chrGlobalPara.ToString().Trim() != "") { strColumns += "chrGlobalPara,"; strValues += "'" + Scheme_DynamicParameterList.chrGlobalPara + "',"; } if (Scheme_DynamicParameterList.ChangeDate != null && Scheme_DynamicParameterList.ChangeDate.ToString().Trim() != "") { strColumns += "ChangeDate,"; strValues += "'" + Scheme_DynamicParameterList.ChangeDate + "',"; } if (Scheme_DynamicParameterList.chrEditor != null && Scheme_DynamicParameterList.chrEditor.ToString().Trim() != "") { strColumns += "chrEditor,"; strValues += "'" + Scheme_DynamicParameterList.chrEditor + "',"; } strColumns = strColumns.Substring(0, strColumns.Length - 1); strValues = strValues.Substring(0, strValues.Length - 1); string _SqlText = string.Format("insert into {0}({1}) values({2})", "Scheme_DynamicParameterList", strColumns, strValues); return(_SqlText); }