/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_Search_Para_MDL GetModel(int Search_Para_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Search_Para_ID,Search_Field_ID,ParaType,ParaTypeCN,ControlWidth,CompareType,CompareTypeCN,DefaultValue,SourceSql,OrderId from T_Search_Para "); strSql.Append(" where Search_Para_ID=@Search_Para_ID "); SqlParameter[] parameters = { new SqlParameter("@Search_Para_ID", SqlDbType.Int, 8) }; parameters[0].Value = Search_Para_ID; DigiPower.Onlinecol.Standard.Model.T_Search_Para_MDL model = new DigiPower.Onlinecol.Standard.Model.T_Search_Para_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Search_Para_ID"].ToString() != "") { model.Search_Para_ID = int.Parse(ds.Tables[0].Rows[0]["Search_Para_ID"].ToString()); } if (ds.Tables[0].Rows[0]["Search_Field_ID"].ToString() != "") { model.Search_Field_ID = int.Parse(ds.Tables[0].Rows[0]["Search_Field_ID"].ToString()); } model.ParaType = ds.Tables[0].Rows[0]["ParaType"].ToString(); model.ParaTypeCN = ds.Tables[0].Rows[0]["ParaTypeCN"].ToString(); if (ds.Tables[0].Rows[0]["ControlWidth"].ToString() != "") { model.ControlWidth = int.Parse(ds.Tables[0].Rows[0]["ControlWidth"].ToString()); } model.CompareType = ds.Tables[0].Rows[0]["CompareType"].ToString(); model.CompareTypeCN = ds.Tables[0].Rows[0]["CompareTypeCN"].ToString(); model.DefaultValue = ds.Tables[0].Rows[0]["DefaultValue"].ToString(); model.SourceSql = ds.Tables[0].Rows[0]["SourceSql"].ToString(); if (ds.Tables[0].Rows[0]["OrderId"].ToString() != "") { model.OrderId = int.Parse(ds.Tables[0].Rows[0]["OrderId"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_Search_Para_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Search_Para("); strSql.Append("Search_Field_ID,ParaType,ParaTypeCN,ControlWidth,CompareType,CompareTypeCN,DefaultValue,SourceSql,OrderId)"); strSql.Append(" values ("); strSql.Append("@Search_Field_ID,@ParaType,@ParaTypeCN,@ControlWidth,@CompareType,@CompareTypeCN,@DefaultValue,@SourceSql,@OrderId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Search_Field_ID", SqlDbType.Int, 8), new SqlParameter("@ParaType", SqlDbType.VarChar, 10), new SqlParameter("@ParaTypeCN", SqlDbType.VarChar, 10), new SqlParameter("@ControlWidth", SqlDbType.Int, 8), new SqlParameter("@CompareType", SqlDbType.VarChar, 10), new SqlParameter("@CompareTypeCN", SqlDbType.VarChar, 10), new SqlParameter("@DefaultValue", SqlDbType.VarChar, 50), new SqlParameter("@SourceSql", SqlDbType.VarChar, 200), new SqlParameter("@OrderId", SqlDbType.Int, 8) }; parameters[0].Value = model.Search_Field_ID; parameters[1].Value = model.ParaType; parameters[2].Value = model.ParaTypeCN; parameters[3].Value = model.ControlWidth; parameters[4].Value = model.CompareType; parameters[5].Value = model.CompareTypeCN; parameters[6].Value = model.DefaultValue; parameters[7].Value = model.SourceSql; parameters[8].Value = model.OrderId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_Search_Para_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Search_Para set "); strSql.Append("Search_Field_ID=@Search_Field_ID,"); strSql.Append("ParaType=@ParaType,"); strSql.Append("ParaTypeCN=@ParaTypeCN,"); strSql.Append("ControlWidth=@ControlWidth,"); strSql.Append("CompareType=@CompareType,"); strSql.Append("CompareTypeCN=@CompareTypeCN,"); strSql.Append("DefaultValue=@DefaultValue,"); strSql.Append("SourceSql=@SourceSql,"); strSql.Append("OrderId=@OrderId"); strSql.Append(" where Search_Para_ID=@Search_Para_ID "); SqlParameter[] parameters = { new SqlParameter("@Search_Para_ID", SqlDbType.Int, 8), new SqlParameter("@Search_Field_ID", SqlDbType.Int, 8), new SqlParameter("@ParaType", SqlDbType.VarChar, 10), new SqlParameter("@ParaTypeCN", SqlDbType.VarChar, 10), new SqlParameter("@ControlWidth", SqlDbType.Int, 8), new SqlParameter("@CompareType", SqlDbType.VarChar, 10), new SqlParameter("@CompareTypeCN", SqlDbType.VarChar, 10), new SqlParameter("@DefaultValue", SqlDbType.VarChar, 50), new SqlParameter("@SourceSql", SqlDbType.VarChar, 200), new SqlParameter("@OrderId", SqlDbType.Int, 8) }; parameters[0].Value = model.Search_Para_ID; parameters[1].Value = model.Search_Field_ID; parameters[2].Value = model.ParaType; parameters[3].Value = model.ParaTypeCN; parameters[4].Value = model.ControlWidth; parameters[5].Value = model.CompareType; parameters[6].Value = model.CompareTypeCN; parameters[7].Value = model.DefaultValue; parameters[8].Value = model.SourceSql; parameters[9].Value = model.OrderId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }