//绑定项目进度
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));
}
