//绑定项目进度 public DataSet SelectPRMProject(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PRMPS_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPS_ID; return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_S_PRMProject_Postpone", parm)); }
//删除会签部门 public void DeletePRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PRMPC_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPC_ID; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_D_PRMProjectCountersign", parm); }
//生成验收部门 public void InsertPRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[2]; parm[0] = new SqlParameter("@PRMP_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMP_ID; parm[1] = new SqlParameter("@PRMPC_SignPartment", SqlDbType.VarChar, 200); parm[1].Value = pRMProjectinfo.PRMPC_SignPartment; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PRMProjectCountersign", parm); }
//项目验收会签 public void UpdatePRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PRMPC_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPC_ID; parm[1] = new SqlParameter("@PRMPC_SignOpinion", SqlDbType.VarChar, 400); parm[1].Value = pRMProjectinfo.PRMPC_SignOpinion; parm[2] = new SqlParameter("@PRMPC_SignResult", SqlDbType.VarChar, 20); parm[2].Value = pRMProjectinfo.PRMPC_SignResult; parm[3] = new SqlParameter("@PRMPC_SignMan", SqlDbType.VarChar, 20); parm[3].Value = pRMProjectinfo.PRMPC_SignMan; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PRMProjectCountersign", parm); }
//延期设置 public void InsertPRMProject_Postpone(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PRMPS_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPS_ID; parm[1] = new SqlParameter("@PRMPS_RelayDay", SqlDbType.Int); parm[1].Value = pRMProjectinfo.PRMPS_RelayDay; parm[2] = new SqlParameter("@PRMPS_RelayReason", SqlDbType.VarChar, 400); parm[2].Value = pRMProjectinfo.PRMPS_RelayReason; parm[3] = new SqlParameter("@PRMPS_RelayMan", SqlDbType.VarChar, 50); parm[3].Value = pRMProjectinfo.PRMPS_RelayMan; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PRMProject_Postpone", parm); }
//插入附件 public void InsertPRMPS_Accessory(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PRMPS_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPS_ID; parm[1] = new SqlParameter("@PRMPS_AccNum ", SqlDbType.VarChar, 100); parm[1].Value = pRMProjectinfo.PRMPS_AccNum; parm[2] = new SqlParameter("@PRMPS_AccName", SqlDbType.VarChar, 100); parm[2].Value = pRMProjectinfo.PRMPS_AccName; parm[3] = new SqlParameter("@PRMPS_Accessory", SqlDbType.Char, 2); parm[3].Value = pRMProjectinfo.PRMPS_Accessory; parm[4] = new SqlParameter("@PRMPS_AccessoryPath", SqlDbType.VarChar, 100); parm[4].Value = pRMProjectinfo.PRMPS_AccessoryPath; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PRMPS_Accessory", parm); }
//填写进度 public void InsertPRMProject_Schedule(PRMProjectinfo pRMProjectinfo) { SqlParameter[] parm = new SqlParameter[9]; parm[0] = new SqlParameter("@PRMPS_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pRMProjectinfo.PRMPS_ID; parm[1] = new SqlParameter("@PRMPS_ScheduleFinish", SqlDbType.Char, 2); parm[1].Value = pRMProjectinfo.PRMPS_ScheduleFinish; parm[2] = new SqlParameter("@PRMPS_ProcessCondition", SqlDbType.VarChar, 400); parm[2].Value = pRMProjectinfo.PRMPS_ProcessCondition; parm[3] = new SqlParameter("@PRMPS_WorkOrderNum", SqlDbType.VarChar, 100); parm[3].Value = pRMProjectinfo.PRMPS_WorkOrderNum; parm[4] = new SqlParameter("@PRMPS_Accessory", SqlDbType.Char, 2); parm[4].Value = pRMProjectinfo.PRMPS_Accessory; parm[5] = new SqlParameter("@PRMPS_ProcessMan", SqlDbType.VarChar, 20); parm[5].Value = pRMProjectinfo.PRMPS_ProcessMan; parm[6] = new SqlParameter("@PRMPS_AccessoryPath", SqlDbType.VarChar, 100); parm[6].Value = pRMProjectinfo.PRMPS_AccessoryPath; parm[7] = new SqlParameter("@PRMPS_AccNum", SqlDbType.VarChar, 100); parm[7].Value = pRMProjectinfo.PRMPS_AccNum; parm[8] = new SqlParameter("@PRMPS_AccName", SqlDbType.VarChar, 100); parm[8].Value = pRMProjectinfo.PRMPS_AccName; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PRMProject_Schedule", parm); }
public void UpdatePRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { PRMP.UpdatePRMProjectCountersign(pRMProjectinfo); }
public void UpdatePRMProjectResponDepart(PRMProjectinfo pRMProjectinfo) { PRMP.UpdatePRMProjectResponDepart(pRMProjectinfo); }
public void UpdatePRMProjectCFOCheck(PRMProjectinfo pRMProjectinfo) { PRMP.UpdatePRMProjectCFOCheck(pRMProjectinfo); }
public void DeletePRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { PRMP.DeletePRMProjectCountersign(pRMProjectinfo); }
public void InsertPRMProjectAccessory(PRMProjectinfo pRMProjectinfo) { PRMP.InsertPRMProjectAccessory(pRMProjectinfo); }
public void DeletePRMProjectAccessory(PRMProjectinfo pRMProjectinfo) { PRMP.DeletePRMProjectAccessory(pRMProjectinfo); }
public void InsertPRMProject_Schedule(PRMProjectinfo pRMProjectinfo) { PRMP.InsertPRMProject_Schedule(pRMProjectinfo); }
public void InsertPRMProject_Postpone(PRMProjectinfo pRMProjectinfo) { PRMP.InsertPRMProject_Postpone(pRMProjectinfo); }
public void InsertPRMProjectCountersign(PRMProjectinfo pRMProjectinfo) { PRMP.InsertPRMProjectCountersign(pRMProjectinfo); }
public DataSet SelectPRMProject_Schedule(PRMProjectinfo pRMProjectinfo) { return(PRMP.SelectPRMProject_Schedule(pRMProjectinfo)); }
//进度明细表绑定 private void BindGridview2(PRMProjectinfo PRMProjectinfo) { Gridview2.DataSource = ppm.SelectPRMProject_Schedule(PRMProjectinfo); Gridview2.DataBind(); }
public void UpdatePRMProjectAccessory(PRMProjectinfo pRMProjectinfo) { PRMP.UpdatePRMProjectAccessory(pRMProjectinfo); }
public DataSet SelectPRMProject(PRMProjectinfo pRMProjectinfo) { return(PRMP.SelectPRMProject(pRMProjectinfo)); }