public class ASDL
{
public ASDL() { }
public int ASD_ID;
public string ASD_SendID;
public int ASD_LsNum;
public string ASD_LsNumber;
public string ASD_JbUserID;
public string ASD_JbUserName;
public string ASD_Date;
public string ASD_UserID;
public string ASD_UserName;
public string ASD_DT_ID;
public string ASD_YDSC;
public string ASD_Name;
public string ASD_Unit;
public string ASD_Secrecy;
public string ASD_Number;
public string ASD_State;
public string ASD_Content;
public string ASD_NodeNum;
public string ASD_NextNodeNum;
public bool ASD_Stop;
public string ASD_OA_ID;
public string ASD_EndDate;
}
public class AddSendDocLib : DbPublic
{
public AddSendDocLib()
: base()
{
}
public static int Add(ASDL model)
{
SqlParameter[] parameters = {
new SqlParameter("@ASD_ID", SqlDbType.Int,4),
new SqlParameter("@ASD_SendID", SqlDbType.VarChar,50),
new SqlParameter("@ASD_LsNum", SqlDbType.Int,4),
new SqlParameter("@ASD_LsNumber", SqlDbType.VarChar,100),
new SqlParameter("@ASD_JbUserID", SqlDbType.VarChar,1000),
new SqlParameter("@ASD_JbUserName", SqlDbType.VarChar,1000),
new SqlParameter("@ASD_Date", SqlDbType.DateTime),
new SqlParameter("@ASD_UserID", SqlDbType.VarChar,50),
new SqlParameter("@ASD_UserName", SqlDbType.VarChar,50),
new SqlParameter("@ASD_DT_ID", SqlDbType.VarChar,50),
new SqlParameter("@ASD_Content", SqlDbType.NText),
new SqlParameter("@ASD_YDSC", SqlDbType.VarChar,50),
new SqlParameter("@ASD_Name", SqlDbType.VarChar,500),
new SqlParameter("@ASD_Unit", SqlDbType.VarChar,50),
new SqlParameter("@ASD_Secrecy", SqlDbType.VarChar,50),
new SqlParameter("@ASD_Number", SqlDbType.VarChar,50),
new SqlParameter("@ASD_State", SqlDbType.VarChar,20),
new SqlParameter("@ASD_NodeNum", SqlDbType.VarChar,50),
new SqlParameter("@ASD_NextNodeNum", SqlDbType.VarChar,50),
new SqlParameter("@ASD_Stop", SqlDbType.Bit,1),
new SqlParameter("@ASD_OA_ID", SqlDbType.VarChar,50),
new SqlParameter("@ASD_EndDate", SqlDbType.DateTime)};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.ASD_SendID;
parameters[2].Value = model.ASD_LsNum;
parameters[3].Value = model.ASD_LsNumber;
parameters[4].Value = model.ASD_JbUserID;
parameters[5].Value = model.ASD_JbUserName;
parameters[6].Value = model.ASD_Date;
parameters[7].Value = model.ASD_UserID;
parameters[8].Value = model.ASD_UserName;
parameters[9].Value = model.ASD_DT_ID;
parameters[10].Value = model.ASD_YDSC;
parameters[11].Value = model.ASD_Name;
parameters[12].Value = model.ASD_Unit;
parameters[13].Value = model.ASD_Secrecy;
parameters[14].Value = model.ASD_Number;
parameters[15].Value = model.ASD_State;
parameters[16].Value = model.ASD_Content;
parameters[17].Value = model.ASD_NodeNum;
parameters[18].Value = model.ASD_NextNodeNum;
parameters[19].Value = model.ASD_Stop;
parameters[20].Value = model.ASD_OA_ID;
if (model.ASD_EndDate == "")
{
parameters[21].Value = DBNull.Value;
}
else
{
parameters[21].Value = model.ASD_EndDate;
}
RunProcedure("Pro_T_AddSendDoc_ADD", parameters);
return (int)parameters[0].Value;