/// <summary>
/// 插入新的表单数据
/// </summary>
/// <param name="info"></param>
public static void InsertJC_FinalistApprovalInfo(JC_FinalistApprovalInfo info)
{
SqlParameter[] parameters =
{
new SqlParameter("@FormID", SqlDbType.NVarChar, 100),
new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100),
new SqlParameter("@ReportDept", SqlDbType.NVarChar, 100),
new SqlParameter("@ReportDate", SqlDbType.NVarChar, 100),
new SqlParameter("@IsAccreditByGroup", SqlDbType.NVarChar, 100),
new SqlParameter("@CheckStatus", SqlDbType.NVarChar, 2000),
//new SqlParameter("@ArchiveDate",SqlDbType.NVarChar,100),
//new SqlParameter("@ArchiveName",SqlDbType.NVarChar,100),
new SqlParameter("@StartDeptId", SqlDbType.NVarChar, 100),
new SqlParameter("@GroupPurchaseDept", SqlDbType.NVarChar, 100),
new SqlParameter("@GroupLegalDept", SqlDbType.NVarChar, 100),
};
parameters[0].Value = info.FormID;
parameters[1].Value = info.ProjectName;
parameters[2].Value = info.ReportDept;
parameters[3].Value = info.ReportDate;
parameters[4].Value = info.IsAccreditByGroup;
parameters[5].Value = info.CheckStatus;
parameters[6].Value = info.StartDeptId;
parameters[7].Value = info.GroupPurchaseDept;
parameters[8].Value = info.GroupLegalDept;
DataTable datatable = DBHelper.ExecutedProcedure("Biz.JC_FinalistApprovalInfo_Insert", parameters);
}
/// <summary>
/// 得到一个实体对象【封装】
/// </summary>
/// <param name="dataRow"></param>
/// <returns></returns>
private static JC_FinalistApprovalInfo DataRowToModel(DataRow dataRow)
{
JC_FinalistApprovalInfo info = new JC_FinalistApprovalInfo();
if (dataRow != null)
{
if (dataRow["FormID"] != null)
{
info.FormID = dataRow["FormID"].ToString();
}
if (dataRow["ProjectName"] != null)
{
info.ProjectName = dataRow["ProjectName"].ToString();
}
if (dataRow["ReportDept"] != null)
{
info.ReportDept = dataRow["ReportDept"].ToString();
}
if (dataRow["ReportDate"] != null)
{
info.ReportDate = dataRow["ReportDate"].ToString();
}
if (dataRow["IsAccreditByGroup"] != null)
{
info.IsAccreditByGroup = dataRow["IsAccreditByGroup"].ToString();
}
if (dataRow["CheckStatus"] != null)
{
info.CheckStatus = dataRow["CheckStatus"].ToString();
}
if (dataRow["GroupPurchaseDept"] != null)
{
info.GroupPurchaseDept = dataRow["GroupPurchaseDept"].ToString();
}
if (dataRow["GroupLegalDept"] != null)
{
info.GroupLegalDept = dataRow["GroupLegalDept"].ToString();
}
if (dataRow["StartDeptId"] != null)
{
info.StartDeptId = dataRow["StartDeptId"].ToString();
}
if (dataRow["IsApproval"] != null)
{
info.IsApproval = dataRow["IsApproval"].ToString();
}
}
return(info);
}
//appflow_2003
public JC_FinalistApprovalInfo GetJC_FinalistApprovalInfo(string formId)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100),
};
parameters[0].Value = formId;
JC_FinalistApprovalInfo model = new JC_FinalistApprovalInfo();
DataTable datatable = DBHelper.ExecutedProcedure("Biz.JC_FinalistApprovalInfoInfoByFormID_Get", parameters);
if (datatable != null && datatable.Rows.Count > 0)
{
return(DataRowToModel(datatable.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 通过formid得到JC_BidScaling的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static JC_BidScalingInfo GetJC_BidScalingInfoByWfId(string id)
{
SqlParameter[] parameters =
{
new SqlParameter("ID", SqlDbType.NVarChar, 100)
};
parameters[0].Value = id;
JC_FinalistApprovalInfo model = new JC_FinalistApprovalInfo();
DataTable dt = DBHelper.ExecutedProcedure("Biz.JC_BidScalingInfoByWfId_Get", parameters);
if (dt != null && dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 通过FormID更新表单IsApproval字段
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static JC_FinalistApprovalInfo UpdateJC_FinalistApprovalInfoInfoByModel(JC_FinalistApprovalInfo 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_FinalistApprovalInfoByID_Update", parameters);
return(model);
}
