/// <summary> /// 通过formid更新IsApproval字段 /// </summary> /// <param name="model"></param> public static JC_BidScalingInfo UpdateJC_BidScalingInfoInfoByModel(JC_BidScalingInfo model) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100), new SqlParameter("@IsApproval", System.Data.SqlDbType.NVarChar, 100), }; parameters[0].Value = model.FormID; parameters[1].Value = model.IsApproval; DataTable dataTable = DBHelper.ExecutedProcedure("Biz.JC_BidScalingInfoByID_Update", parameters); return(model); }
public JC_BidScalingInfo GetBidScalingInfo(string formId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100), }; parameters[0].Value = formId; JC_BidScalingInfo model = new JC_BidScalingInfo(); DataTable datatable = DBHelper.ExecutedProcedure("Biz.JC_GetBidScaling", parameters); if (datatable != null && datatable.Rows.Count > 0) { return(DataRowToModel(datatable.Rows[0])); } else { return(null); } }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBidScaling(JC_BidScalingInfo model) { string methodName = "UpdateBidScaling"; Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("JC_BidScalingInfo={0}", model)); DataProvider db = new DataProvider(); db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; string sql = string.Format("Update Biz.JC_BidScaling set StartDeptCode='{0}',Title = '{1}',DeptName = '{2}',UserName='******'," + "DateTime='{4}',Content='{5}',EntranceTime='{6}',IsAccreditByGroup='{7}',FirstLevel='{8}',FirstUnit='{9}',SecondUnit='{10}'," + "ScalingResult ='{11}',BidCommittee = '{12}',IsApproval = '{13}' where FormID = '{14}'", model.StartDeptCode, model.Title, model.DeptName, model.UserName, model.DateTime, model.Content, model.EntranceTime, model.IsAccreditByGroup, model.FirstLevel, model.FirstUnit, model.SecondUnit, model.ScalingResult, model.BidCommittee, model.IsApproval, model.FormID); if (db.ExecuteNonQuery(sql, CommandType.Text) > 0) { return(true); } return(false); }
public JC_BidScalingInfo GetBidScaling(string FormID) { string methodName = "GetBidScaling"; 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) }; parameters[0].Value = FormID; DataTable dt = db.ExecutedProcedure("Biz.JC_GetBidScaling", parameters); JC_BidScalingInfo jcInfo = new JC_BidScalingInfo(); if (dt != null && dt.Rows.Count > 0) { jcInfo.FormID = Assign(dt.Rows[0]["FormID"]); jcInfo.StartDeptCode = Assign(dt.Rows[0]["StartDeptCode"]); jcInfo.Title = Assign(dt.Rows[0]["Title"]); jcInfo.DeptName = Assign(dt.Rows[0]["DeptName"]); jcInfo.UserName = Assign(dt.Rows[0]["UserName"]); jcInfo.DateTime = Assign(dt.Rows[0]["DateTime"]); jcInfo.Content = Assign(dt.Rows[0]["Content"]); jcInfo.EntranceTime = Assign(dt.Rows[0]["EntranceTime"]); jcInfo.IsAccreditByGroup = Assign(dt.Rows[0]["IsAccreditByGroup"]); jcInfo.FirstLevel = Assign(dt.Rows[0]["FirstLevel"]); jcInfo.FirstUnit = Assign(dt.Rows[0]["FirstUnit"]); jcInfo.SecondUnit = Assign(dt.Rows[0]["SecondUnit"]); jcInfo.ScalingResult = Assign(dt.Rows[0]["ScalingResult"]); jcInfo.BidCommittee = Assign(dt.Rows[0]["BidCommittee"]); jcInfo.IsApproval = Assign(dt.Rows[0]["IsApproval"]); return(jcInfo); } return(null); }
/// <summary> /// 封装实体 /// </summary> /// <param name="dataRow"></param> /// <returns></returns> private static JC_BidScalingInfo DataRowToModel(DataRow dataRow) { JC_BidScalingInfo info = new JC_BidScalingInfo(); if (dataRow != null) { if (dataRow["FormID"] != null) { info.FormID = dataRow["FormID"].ToString(); } if (dataRow["StartDeptCode"] != null) { info.StartDeptCode = dataRow["StartDeptCode"].ToString(); } if (dataRow["Title"] != null) { info.Title = dataRow["Title"].ToString(); } if (dataRow["DeptName"] != null) { info.DeptName = dataRow["DeptName"].ToString(); } if (dataRow["UserName"] != null) { info.UserName = dataRow["UserName"].ToString(); } if (dataRow["DateTime"] != null) { info.DateTime = dataRow["DateTime"].ToString(); } if (dataRow["Content"] != null) { info.Content = dataRow["Content"].ToString(); } if (dataRow["EntranceTime"] != null) { info.EntranceTime = dataRow["EntranceTime"].ToString(); } if (dataRow["IsAccreditByGroup"] != null) { info.IsAccreditByGroup = dataRow["IsAccreditByGroup"].ToString(); } if (dataRow["FirstLevel"] != null) { info.FirstLevel = dataRow["FirstLevel"].ToString(); } if (dataRow["FirstUnit"] != null) { info.FirstUnit = dataRow["FirstUnit"].ToString(); } if (dataRow["SecondUnit"] != null) { info.SecondUnit = dataRow["SecondUnit"].ToString(); } if (dataRow["ScalingResult"] != null) { info.ScalingResult = dataRow["ScalingResult"].ToString(); } if (dataRow["BidCommittee"] != null) { info.BidCommittee = dataRow["BidCommittee"].ToString(); } if (dataRow["IsApproval"] != null) { info.IsApproval = dataRow["IsApproval"].ToString(); } } return(info); }