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);
}
