public JC_BidScalingListInfo GetBidScalingList(string FormID, string UserCode) { string methodName = "GetBidScalingList"; Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("ID={0}", FormID)); DataProvider db = new DataProvider(); db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100) , new SqlParameter("@UserCode", System.Data.SqlDbType.NVarChar, 100) }; parameters[0].Value = FormID; parameters[1].Value = UserCode; DataTable dt = db.ExecutedProcedure("Biz.JC_GetBidScalingList", parameters); JC_BidScalingListInfo jcInfo = new JC_BidScalingListInfo(); if (dt != null && dt.Rows.Count > 0) { jcInfo.FormID = Assign(dt.Rows[0]["FormID"]); jcInfo.UserCode = Assign(dt.Rows[0]["UserCode"]); jcInfo.UserName = Assign(dt.Rows[0]["UserName"]); jcInfo.CreatTime = Assign(dt.Rows[0]["CreatTime"]); jcInfo.SelectResult = Assign(dt.Rows[0]["SelectResult"]); return(jcInfo); } return(null); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBidScalingList(JC_BidScalingListInfo model) { string methodName = "UpdateBidScalingList"; Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("JC_BidScalingListInfo={0}", model)); DataProvider db = new DataProvider(); db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; string sql = string.Format("Update Biz.JC_BidScalingList set UserCode = '{0}',UserName='******',CreatTime='{2}',SelectResult='{3}' where FormID = '{18}'", model.UserCode, model.UserName, model.CreatTime, model.SelectResult, model.FormID); if (db.ExecuteNonQuery(sql, CommandType.Text) > 0) { return(true); } return(false); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool InsertBidScalingList(JC_BidScalingListInfo model) { string methodName = "InsertBidScalingList"; Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("JC_BidScalingListInfo={0}", model)); DataProvider db = new DataProvider(); db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; string sql = string.Format("INSERT INTO Biz.JC_BidScalingList (FormID,UserCode ,UserName,CreatTime, SelectResult) VALUES" + "('{0}','{1}','{2}','{3}','{4}')", model.FormID, model.UserCode, model.UserName, model.CreatTime, model.SelectResult); if (db.ExecuteNonQuery(sql, CommandType.Text) > 0) { return(true); } return(false); }