/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.T_MainFiles GetModel(int n_FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_FileID,s_SendMethod,s_Name,s_Abstact,s_FilePathName,s_IOType,s_ClientGov,n_ProcessID,dt_SendDate,dt_ReceiveDate,dt_CreateDate,dt_EditDate,ObjectType,s_IsActive,n_TemplateID,dt_AppDate,s_PubNo,dt_PubDate,s_CaseSerial,s_AppNo,s_Applicants,s_Introducer,s_Inventors,s_Attorney,s_Creator,s_Editor,n_MainCaseID,s_Status,n_FlowNum,s_InfileFlowNum,s_IsNewCaseInFile,n_NumCount,n_PicCount,s_From,s_To,s_Cc,s_Bc,n_ClientID,s_IPType,n_ApplicantID,n_CreatorID,n_FileClientID,n_FileApplicantID,s_NameForeign,s_ClientType,s_ManualCreateChain,s_sourcetype1 from T_MainFiles ");
strSql.Append(" where n_FileID=@n_FileID");
SqlParameter[] parameters =
{
new SqlParameter("@n_FileID", SqlDbType.Int, 4)
};
parameters[0].Value = n_FileID;
IPSP.Model.T_MainFiles model = new IPSP.Model.T_MainFiles();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.T_MainFiles model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.T_MainFiles model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.T_MainFiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_MainFiles(");
strSql.Append("s_SendMethod,s_Name,s_Abstact,s_FilePathName,s_IOType,s_ClientGov,n_ProcessID,dt_SendDate,dt_ReceiveDate,dt_CreateDate,dt_EditDate,ObjectType,s_IsActive,n_TemplateID,dt_AppDate,s_PubNo,dt_PubDate,s_CaseSerial,s_AppNo,s_Applicants,s_Introducer,s_Inventors,s_Attorney,s_Creator,s_Editor,n_MainCaseID,s_Status,n_FlowNum,s_InfileFlowNum,s_IsNewCaseInFile,n_NumCount,n_PicCount,s_From,s_To,s_Cc,s_Bc,n_ClientID,s_IPType,n_ApplicantID,n_CreatorID,n_FileClientID,n_FileApplicantID,s_NameForeign,s_ClientType,s_ManualCreateChain,s_sourcetype1)");
strSql.Append(" values (");
strSql.Append("@s_SendMethod,@s_Name,@s_Abstact,@s_FilePathName,@s_IOType,@s_ClientGov,@n_ProcessID,@dt_SendDate,@dt_ReceiveDate,@dt_CreateDate,@dt_EditDate,@ObjectType,@s_IsActive,@n_TemplateID,@dt_AppDate,@s_PubNo,@dt_PubDate,@s_CaseSerial,@s_AppNo,@s_Applicants,@s_Introducer,@s_Inventors,@s_Attorney,@s_Creator,@s_Editor,@n_MainCaseID,@s_Status,@n_FlowNum,@s_InfileFlowNum,@s_IsNewCaseInFile,@n_NumCount,@n_PicCount,@s_From,@s_To,@s_Cc,@s_Bc,@n_ClientID,@s_IPType,@n_ApplicantID,@n_CreatorID,@n_FileClientID,@n_FileApplicantID,@s_NameForeign,@s_ClientType,@s_ManualCreateChain,@s_sourcetype1)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@s_SendMethod", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Name", SqlDbType.NVarChar, 400),
new SqlParameter("@s_Abstact", SqlDbType.NVarChar, 1000),
new SqlParameter("@s_FilePathName", SqlDbType.NVarChar, 500),
new SqlParameter("@s_IOType", SqlDbType.NVarChar, 10),
new SqlParameter("@s_ClientGov", SqlDbType.NVarChar, 50),
new SqlParameter("@n_ProcessID", SqlDbType.Int, 4),
new SqlParameter("@dt_SendDate", SqlDbType.DateTime),
new SqlParameter("@dt_ReceiveDate", SqlDbType.DateTime),
new SqlParameter("@dt_CreateDate", SqlDbType.DateTime),
new SqlParameter("@dt_EditDate", SqlDbType.DateTime),
new SqlParameter("@ObjectType", SqlDbType.Int, 4),
new SqlParameter("@s_IsActive", SqlDbType.NVarChar, 1),
new SqlParameter("@n_TemplateID", SqlDbType.Int, 4),
new SqlParameter("@dt_AppDate", SqlDbType.DateTime),
new SqlParameter("@s_PubNo", SqlDbType.VarChar, 50),
new SqlParameter("@dt_PubDate", SqlDbType.DateTime),
new SqlParameter("@s_CaseSerial", SqlDbType.VarChar, 100),
new SqlParameter("@s_AppNo", SqlDbType.VarChar, 100),
new SqlParameter("@s_Applicants", SqlDbType.VarChar, 1000),
new SqlParameter("@s_Introducer", SqlDbType.VarChar, 300),
new SqlParameter("@s_Inventors", SqlDbType.VarChar, 1000),
new SqlParameter("@s_Attorney", SqlDbType.VarChar, 200),
new SqlParameter("@s_Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@n_MainCaseID", SqlDbType.Int, 4),
new SqlParameter("@s_Status", SqlDbType.NVarChar, 100),
new SqlParameter("@n_FlowNum", SqlDbType.Int, 4),
new SqlParameter("@s_InfileFlowNum", SqlDbType.NVarChar, 100),
new SqlParameter("@s_IsNewCaseInFile", SqlDbType.NVarChar, 100),
new SqlParameter("@n_NumCount", SqlDbType.Int, 4),
new SqlParameter("@n_PicCount", SqlDbType.Int, 4),
new SqlParameter("@s_From", SqlDbType.NVarChar, 1000),
new SqlParameter("@s_To", SqlDbType.NVarChar, 3000),
new SqlParameter("@s_Cc", SqlDbType.NVarChar, 3000),
new SqlParameter("@s_Bc", SqlDbType.NVarChar, 3000),
new SqlParameter("@n_ClientID", SqlDbType.Int, 4),
new SqlParameter("@s_IPType", SqlDbType.NVarChar, 1),
new SqlParameter("@n_ApplicantID", SqlDbType.Int, 4),
new SqlParameter("@n_CreatorID", SqlDbType.Int, 4),
new SqlParameter("@n_FileClientID", SqlDbType.Int, 4),
new SqlParameter("@n_FileApplicantID", SqlDbType.Int, 4),
new SqlParameter("@s_NameForeign", SqlDbType.NVarChar, 400),
new SqlParameter("@s_ClientType", SqlDbType.NVarChar, 1),
new SqlParameter("@s_ManualCreateChain", SqlDbType.NVarChar, 1),
new SqlParameter("@s_sourcetype1", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.s_SendMethod;
parameters[1].Value = model.s_Name;
parameters[2].Value = model.s_Abstact;
parameters[3].Value = model.s_FilePathName;
parameters[4].Value = model.s_IOType;
parameters[5].Value = model.s_ClientGov;
parameters[6].Value = model.n_ProcessID;
parameters[7].Value = model.dt_SendDate;
parameters[8].Value = model.dt_ReceiveDate;
parameters[9].Value = model.dt_CreateDate;
parameters[10].Value = model.dt_EditDate;
parameters[11].Value = model.ObjectType;
parameters[12].Value = model.s_IsActive;
parameters[13].Value = model.n_TemplateID;
parameters[14].Value = model.dt_AppDate;
parameters[15].Value = model.s_PubNo;
parameters[16].Value = model.dt_PubDate;
parameters[17].Value = model.s_CaseSerial;
parameters[18].Value = model.s_AppNo;
parameters[19].Value = model.s_Applicants;
parameters[20].Value = model.s_Introducer;
parameters[21].Value = model.s_Inventors;
parameters[22].Value = model.s_Attorney;
parameters[23].Value = model.s_Creator;
parameters[24].Value = model.s_Editor;
parameters[25].Value = model.n_MainCaseID;
parameters[26].Value = model.s_Status;
parameters[27].Value = model.n_FlowNum;
parameters[28].Value = model.s_InfileFlowNum;
parameters[29].Value = model.s_IsNewCaseInFile;
parameters[30].Value = model.n_NumCount;
parameters[31].Value = model.n_PicCount;
parameters[32].Value = model.s_From;
parameters[33].Value = model.s_To;
parameters[34].Value = model.s_Cc;
parameters[35].Value = model.s_Bc;
parameters[36].Value = model.n_ClientID;
parameters[37].Value = model.s_IPType;
parameters[38].Value = model.n_ApplicantID;
parameters[39].Value = model.n_CreatorID;
parameters[40].Value = model.n_FileClientID;
parameters[41].Value = model.n_FileApplicantID;
parameters[42].Value = model.s_NameForeign;
parameters[43].Value = model.s_ClientType;
parameters[44].Value = model.s_ManualCreateChain;
parameters[45].Value = model.s_sourcetype1;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.T_MainFiles DataRowToModel(DataRow row)
{
IPSP.Model.T_MainFiles model = new IPSP.Model.T_MainFiles();
if (row != null)
{
if (row["n_FileID"] != null && row["n_FileID"].ToString() != "")
{
model.n_FileID = int.Parse(row["n_FileID"].ToString());
}
if (row["s_SendMethod"] != null)
{
model.s_SendMethod = row["s_SendMethod"].ToString();
}
if (row["s_Name"] != null)
{
model.s_Name = row["s_Name"].ToString();
}
if (row["s_Abstact"] != null)
{
model.s_Abstact = row["s_Abstact"].ToString();
}
if (row["s_FilePathName"] != null)
{
model.s_FilePathName = row["s_FilePathName"].ToString();
}
if (row["s_IOType"] != null)
{
model.s_IOType = row["s_IOType"].ToString();
}
if (row["s_ClientGov"] != null)
{
model.s_ClientGov = row["s_ClientGov"].ToString();
}
if (row["n_ProcessID"] != null && row["n_ProcessID"].ToString() != "")
{
model.n_ProcessID = int.Parse(row["n_ProcessID"].ToString());
}
if (row["dt_SendDate"] != null && row["dt_SendDate"].ToString() != "")
{
model.dt_SendDate = DateTime.Parse(row["dt_SendDate"].ToString());
}
if (row["dt_ReceiveDate"] != null && row["dt_ReceiveDate"].ToString() != "")
{
model.dt_ReceiveDate = DateTime.Parse(row["dt_ReceiveDate"].ToString());
}
if (row["dt_CreateDate"] != null && row["dt_CreateDate"].ToString() != "")
{
model.dt_CreateDate = DateTime.Parse(row["dt_CreateDate"].ToString());
}
if (row["dt_EditDate"] != null && row["dt_EditDate"].ToString() != "")
{
model.dt_EditDate = DateTime.Parse(row["dt_EditDate"].ToString());
}
if (row["ObjectType"] != null && row["ObjectType"].ToString() != "")
{
model.ObjectType = int.Parse(row["ObjectType"].ToString());
}
if (row["s_IsActive"] != null)
{
model.s_IsActive = row["s_IsActive"].ToString();
}
if (row["n_TemplateID"] != null && row["n_TemplateID"].ToString() != "")
{
model.n_TemplateID = int.Parse(row["n_TemplateID"].ToString());
}
if (row["dt_AppDate"] != null && row["dt_AppDate"].ToString() != "")
{
model.dt_AppDate = DateTime.Parse(row["dt_AppDate"].ToString());
}
if (row["s_PubNo"] != null)
{
model.s_PubNo = row["s_PubNo"].ToString();
}
if (row["dt_PubDate"] != null && row["dt_PubDate"].ToString() != "")
{
model.dt_PubDate = DateTime.Parse(row["dt_PubDate"].ToString());
}
if (row["s_CaseSerial"] != null)
{
model.s_CaseSerial = row["s_CaseSerial"].ToString();
}
if (row["s_AppNo"] != null)
{
model.s_AppNo = row["s_AppNo"].ToString();
}
if (row["s_Applicants"] != null)
{
model.s_Applicants = row["s_Applicants"].ToString();
}
if (row["s_Introducer"] != null)
{
model.s_Introducer = row["s_Introducer"].ToString();
}
if (row["s_Inventors"] != null)
{
model.s_Inventors = row["s_Inventors"].ToString();
}
if (row["s_Attorney"] != null)
{
model.s_Attorney = row["s_Attorney"].ToString();
}
if (row["s_Creator"] != null)
{
model.s_Creator = row["s_Creator"].ToString();
}
if (row["s_Editor"] != null)
{
model.s_Editor = row["s_Editor"].ToString();
}
if (row["n_MainCaseID"] != null && row["n_MainCaseID"].ToString() != "")
{
model.n_MainCaseID = int.Parse(row["n_MainCaseID"].ToString());
}
if (row["s_Status"] != null)
{
model.s_Status = row["s_Status"].ToString();
}
if (row["n_FlowNum"] != null && row["n_FlowNum"].ToString() != "")
{
model.n_FlowNum = int.Parse(row["n_FlowNum"].ToString());
}
if (row["s_InfileFlowNum"] != null)
{
model.s_InfileFlowNum = row["s_InfileFlowNum"].ToString();
}
if (row["s_IsNewCaseInFile"] != null)
{
model.s_IsNewCaseInFile = row["s_IsNewCaseInFile"].ToString();
}
if (row["n_NumCount"] != null && row["n_NumCount"].ToString() != "")
{
model.n_NumCount = int.Parse(row["n_NumCount"].ToString());
}
if (row["n_PicCount"] != null && row["n_PicCount"].ToString() != "")
{
model.n_PicCount = int.Parse(row["n_PicCount"].ToString());
}
if (row["s_From"] != null)
{
model.s_From = row["s_From"].ToString();
}
if (row["s_To"] != null)
{
model.s_To = row["s_To"].ToString();
}
if (row["s_Cc"] != null)
{
model.s_Cc = row["s_Cc"].ToString();
}
if (row["s_Bc"] != null)
{
model.s_Bc = row["s_Bc"].ToString();
}
if (row["n_ClientID"] != null && row["n_ClientID"].ToString() != "")
{
model.n_ClientID = int.Parse(row["n_ClientID"].ToString());
}
if (row["s_IPType"] != null)
{
model.s_IPType = row["s_IPType"].ToString();
}
if (row["n_ApplicantID"] != null && row["n_ApplicantID"].ToString() != "")
{
model.n_ApplicantID = int.Parse(row["n_ApplicantID"].ToString());
}
if (row["n_CreatorID"] != null && row["n_CreatorID"].ToString() != "")
{
model.n_CreatorID = int.Parse(row["n_CreatorID"].ToString());
}
if (row["n_FileClientID"] != null && row["n_FileClientID"].ToString() != "")
{
model.n_FileClientID = int.Parse(row["n_FileClientID"].ToString());
}
if (row["n_FileApplicantID"] != null && row["n_FileApplicantID"].ToString() != "")
{
model.n_FileApplicantID = int.Parse(row["n_FileApplicantID"].ToString());
}
if (row["s_NameForeign"] != null)
{
model.s_NameForeign = row["s_NameForeign"].ToString();
}
if (row["s_ClientType"] != null)
{
model.s_ClientType = row["s_ClientType"].ToString();
}
if (row["s_ManualCreateChain"] != null)
{
model.s_ManualCreateChain = row["s_ManualCreateChain"].ToString();
}
if (row["s_sourcetype1"] != null)
{
model.s_sourcetype1 = row["s_sourcetype1"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.T_MainFiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_MainFiles set ");
strSql.Append("s_SendMethod=@s_SendMethod,");
strSql.Append("s_Name=@s_Name,");
strSql.Append("s_Abstact=@s_Abstact,");
strSql.Append("s_FilePathName=@s_FilePathName,");
strSql.Append("s_IOType=@s_IOType,");
strSql.Append("s_ClientGov=@s_ClientGov,");
strSql.Append("n_ProcessID=@n_ProcessID,");
strSql.Append("dt_SendDate=@dt_SendDate,");
strSql.Append("dt_ReceiveDate=@dt_ReceiveDate,");
strSql.Append("dt_CreateDate=@dt_CreateDate,");
strSql.Append("dt_EditDate=@dt_EditDate,");
strSql.Append("s_IsActive=@s_IsActive,");
strSql.Append("n_TemplateID=@n_TemplateID,");
strSql.Append("dt_AppDate=@dt_AppDate,");
strSql.Append("s_PubNo=@s_PubNo,");
strSql.Append("dt_PubDate=@dt_PubDate,");
strSql.Append("s_CaseSerial=@s_CaseSerial,");
strSql.Append("s_AppNo=@s_AppNo,");
strSql.Append("s_Applicants=@s_Applicants,");
strSql.Append("s_Introducer=@s_Introducer,");
strSql.Append("s_Inventors=@s_Inventors,");
strSql.Append("s_Attorney=@s_Attorney,");
strSql.Append("s_Creator=@s_Creator,");
strSql.Append("s_Editor=@s_Editor,");
strSql.Append("n_MainCaseID=@n_MainCaseID,");
strSql.Append("s_Status=@s_Status,");
strSql.Append("n_FlowNum=@n_FlowNum,");
strSql.Append("s_InfileFlowNum=@s_InfileFlowNum,");
strSql.Append("s_IsNewCaseInFile=@s_IsNewCaseInFile,");
strSql.Append("n_NumCount=@n_NumCount,");
strSql.Append("n_PicCount=@n_PicCount,");
strSql.Append("s_From=@s_From,");
strSql.Append("s_To=@s_To,");
strSql.Append("s_Cc=@s_Cc,");
strSql.Append("s_Bc=@s_Bc,");
strSql.Append("s_IPType=@s_IPType,");
strSql.Append("n_CreatorID=@n_CreatorID,");
strSql.Append("s_NameForeign=@s_NameForeign,");
strSql.Append("s_ClientType=@s_ClientType,");
strSql.Append("s_ManualCreateChain=@s_ManualCreateChain,");
strSql.Append("s_sourcetype1=@s_sourcetype1");
strSql.Append(" where n_FileID=@n_FileID");
SqlParameter[] parameters =
{
new SqlParameter("@s_SendMethod", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Name", SqlDbType.NVarChar, 400),
new SqlParameter("@s_Abstact", SqlDbType.NVarChar, 1000),
new SqlParameter("@s_FilePathName", SqlDbType.NVarChar, 500),
new SqlParameter("@s_IOType", SqlDbType.NVarChar, 10),
new SqlParameter("@s_ClientGov", SqlDbType.NVarChar, 50),
new SqlParameter("@n_ProcessID", SqlDbType.Int, 4),
new SqlParameter("@dt_SendDate", SqlDbType.DateTime),
new SqlParameter("@dt_ReceiveDate", SqlDbType.DateTime),
new SqlParameter("@dt_CreateDate", SqlDbType.DateTime),
new SqlParameter("@dt_EditDate", SqlDbType.DateTime),
new SqlParameter("@s_IsActive", SqlDbType.NVarChar, 1),
new SqlParameter("@n_TemplateID", SqlDbType.Int, 4),
new SqlParameter("@dt_AppDate", SqlDbType.DateTime),
new SqlParameter("@s_PubNo", SqlDbType.VarChar, 50),
new SqlParameter("@dt_PubDate", SqlDbType.DateTime),
new SqlParameter("@s_CaseSerial", SqlDbType.VarChar, 100),
new SqlParameter("@s_AppNo", SqlDbType.VarChar, 100),
new SqlParameter("@s_Applicants", SqlDbType.VarChar, 1000),
new SqlParameter("@s_Introducer", SqlDbType.VarChar, 300),
new SqlParameter("@s_Inventors", SqlDbType.VarChar, 1000),
new SqlParameter("@s_Attorney", SqlDbType.VarChar, 200),
new SqlParameter("@s_Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@n_MainCaseID", SqlDbType.Int, 4),
new SqlParameter("@s_Status", SqlDbType.NVarChar, 100),
new SqlParameter("@n_FlowNum", SqlDbType.Int, 4),
new SqlParameter("@s_InfileFlowNum", SqlDbType.NVarChar, 100),
new SqlParameter("@s_IsNewCaseInFile", SqlDbType.NVarChar, 100),
new SqlParameter("@n_NumCount", SqlDbType.Int, 4),
new SqlParameter("@n_PicCount", SqlDbType.Int, 4),
new SqlParameter("@s_From", SqlDbType.NVarChar, 1000),
new SqlParameter("@s_To", SqlDbType.NVarChar, 3000),
new SqlParameter("@s_Cc", SqlDbType.NVarChar, 3000),
new SqlParameter("@s_Bc", SqlDbType.NVarChar, 3000),
new SqlParameter("@s_IPType", SqlDbType.NVarChar, 1),
new SqlParameter("@n_CreatorID", SqlDbType.Int, 4),
new SqlParameter("@s_NameForeign", SqlDbType.NVarChar, 400),
new SqlParameter("@s_ClientType", SqlDbType.NVarChar, 1),
new SqlParameter("@s_ManualCreateChain", SqlDbType.NVarChar, 1),
new SqlParameter("@s_sourcetype1", SqlDbType.VarChar, 500),
new SqlParameter("@n_FileID", SqlDbType.Int, 4),
new SqlParameter("@ObjectType", SqlDbType.Int, 4),
new SqlParameter("@n_ClientID", SqlDbType.Int, 4),
new SqlParameter("@n_ApplicantID", SqlDbType.Int, 4),
new SqlParameter("@n_FileClientID", SqlDbType.Int, 4),
new SqlParameter("@n_FileApplicantID", SqlDbType.Int, 4)
};
parameters[0].Value = model.s_SendMethod;
parameters[1].Value = model.s_Name;
parameters[2].Value = model.s_Abstact;
parameters[3].Value = model.s_FilePathName;
parameters[4].Value = model.s_IOType;
parameters[5].Value = model.s_ClientGov;
parameters[6].Value = model.n_ProcessID;
parameters[7].Value = model.dt_SendDate;
parameters[8].Value = model.dt_ReceiveDate;
parameters[9].Value = model.dt_CreateDate;
parameters[10].Value = model.dt_EditDate;
parameters[11].Value = model.s_IsActive;
parameters[12].Value = model.n_TemplateID;
parameters[13].Value = model.dt_AppDate;
parameters[14].Value = model.s_PubNo;
parameters[15].Value = model.dt_PubDate;
parameters[16].Value = model.s_CaseSerial;
parameters[17].Value = model.s_AppNo;
parameters[18].Value = model.s_Applicants;
parameters[19].Value = model.s_Introducer;
parameters[20].Value = model.s_Inventors;
parameters[21].Value = model.s_Attorney;
parameters[22].Value = model.s_Creator;
parameters[23].Value = model.s_Editor;
parameters[24].Value = model.n_MainCaseID;
parameters[25].Value = model.s_Status;
parameters[26].Value = model.n_FlowNum;
parameters[27].Value = model.s_InfileFlowNum;
parameters[28].Value = model.s_IsNewCaseInFile;
parameters[29].Value = model.n_NumCount;
parameters[30].Value = model.n_PicCount;
parameters[31].Value = model.s_From;
parameters[32].Value = model.s_To;
parameters[33].Value = model.s_Cc;
parameters[34].Value = model.s_Bc;
parameters[35].Value = model.s_IPType;
parameters[36].Value = model.n_CreatorID;
parameters[37].Value = model.s_NameForeign;
parameters[38].Value = model.s_ClientType;
parameters[39].Value = model.s_ManualCreateChain;
parameters[40].Value = model.s_sourcetype1;
parameters[41].Value = model.n_FileID;
parameters[42].Value = model.ObjectType;
parameters[43].Value = model.n_ClientID;
parameters[44].Value = model.n_ApplicantID;
parameters[45].Value = model.n_FileClientID;
parameters[46].Value = model.n_FileApplicantID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}