/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(ContractApprovalInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@FormID", SqlDbType.NVarChar, 100),
new SqlParameter("@ErpFormId", SqlDbType.NVarChar, 100),
new SqlParameter("@ErpFormType", SqlDbType.NVarChar, 100),
new SqlParameter("@StartDeptId", SqlDbType.NVarChar, 100),
new SqlParameter("@IsReportToResource", SqlDbType.Int, 4),
new SqlParameter("@IsReportToFounder", SqlDbType.Int, 4),
new SqlParameter("@IsOverContract", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.NVarChar, 100),
new SqlParameter("@ApproveResult", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.FormID;
parameters[1].Value = model.ErpFormId;
parameters[2].Value = model.ErpFormType;
parameters[3].Value = model.StartDeptId;
parameters[4].Value = model.IsReportToResource;
parameters[5].Value = model.IsReportToFounder;
parameters[6].Value = model.IsOverContract;
parameters[7].Value = model.CreateTime;
parameters[8].Value = model.ApproveResult;
DataTable dataTable = DBHelper.ExecutedProcedure("Biz.ERP_ContractApproval_Update", parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static ContractApprovalInfo DataRowToModel(DataRow row)
{
ContractApprovalInfo model = new ContractApprovalInfo();
if (row != null)
{
if (row["FormID"] != null)
{
model.FormID = row["FormID"].ToString();
}
if (row["ErpFormId"] != null)
{
model.ErpFormId = row["ErpFormId"].ToString();
}
if (row["ErpFormType"] != null)
{
model.ErpFormType = row["ErpFormType"].ToString();
}
if (row["StartDeptId"] != null)
{
model.StartDeptId = row["StartDeptId"].ToString();
}
if (row["IsReportToResource"] != null && row["IsReportToResource"].ToString() != "")
{
model.IsReportToResource = int.Parse(row["IsReportToResource"].ToString());
}
if (row["IsReportToFounder"] != null && row["IsReportToFounder"].ToString() != "")
{
model.IsReportToFounder = int.Parse(row["IsReportToFounder"].ToString());
}
if (row["IsOverContract"] != null && row["IsOverContract"].ToString() != "")
{
model.IsOverContract = int.Parse(row["IsOverContract"].ToString());
}
if (row["CreateTime"] != null)
{
model.CreateTime = row["CreateTime"].ToString();
}
if (row["ApproveResult"] != null)
{
model.ApproveResult = row["ApproveResult"].ToString();
}
}
return(model);
}
/// <summary>
/// 通过formid1得到instanceid
/// </summary>
/// <param name="formid1"></param>
/// <returns></returns>
public static string GetContractApprovalInstanceIdByFormId(string formid1)
{
SqlParameter[] parameters =
{
new SqlParameter("@formid1", SqlDbType.NVarChar, 100)
};
parameters[0].Value = formid1;
ContractApprovalInfo model = new ContractApprovalInfo();
DataTable dt = DBHelper.ExecutedProcedure("Biz.ERP_GetContractApprovalInstanceIdByFormId", parameters);
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0][0].ToString());
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static ContractApprovalInfo GetModel(string FormID)
{
SqlParameter[] parameters =
{
new SqlParameter("@FormID", SqlDbType.NVarChar, 100)
};
parameters[0].Value = FormID;
ContractApprovalInfo model = new ContractApprovalInfo();
DataTable dt = DBHelper.ExecutedProcedure("Biz.ERP_ContractApproval_GetModel", parameters);
if (dt != null && dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
public static SupplementalAgreementInfo GetModelByWfId(string id)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 100)
};
parameters[0].Value = id;
ContractApprovalInfo model = new ContractApprovalInfo();
DataTable dt = DBHelper.ExecutedProcedure("Biz.ERP_SupplementalAgreement_GetModelByWfId", parameters);
if (dt != null && dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}