/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.T_Task GetModel(int n_TaskID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_TaskID,s_TaskType,n_SysTaskCodeID,n_EmployeeID,s_TaskToEmail,s_Level,s_TaskName,s_TaskDetail,dt_AlarmDate,dt_InterDeadline,dt_ClientDeadline,dt_OfficialDeadline,dt_Deadline,s_Status,dt_StatusDate,s_IsActive,dt_CreateDate,dt_EditDate,n_FileID,s_TaskTo,n_CameFileID,n_OutFileID,n_FeeID,n_BillID,s_Applicants,s_CaseSerial,s_Country,s_AppNo,s_Introducer,s_Attorney,s_Creator,s_Editor,s_InRecycle,n_ModuleCheckStatusID,n_LatestCheckInfoID,n_AuthorID,n_CurCheckerID,s_TaskResult,n_MainCaseID,s_Category,s_RenewalDeadline from T_Task ");
strSql.Append(" where n_TaskID=@n_TaskID");
SqlParameter[] parameters =
{
new SqlParameter("@n_TaskID", SqlDbType.Int, 4)
};
parameters[0].Value = n_TaskID;
IPSP.Model.T_Task model = new IPSP.Model.T_Task();
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 int Add(IPSP.Model.T_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Task(");
strSql.Append("s_TaskType,n_SysTaskCodeID,n_EmployeeID,s_TaskToEmail,s_Level,s_TaskName,s_TaskDetail,dt_AlarmDate,dt_InterDeadline,dt_ClientDeadline,dt_OfficialDeadline,dt_Deadline,s_Status,dt_StatusDate,s_IsActive,dt_CreateDate,dt_EditDate,n_FileID,s_TaskTo,n_CameFileID,n_OutFileID,n_FeeID,n_BillID,s_Applicants,s_CaseSerial,s_Country,s_AppNo,s_Introducer,s_Attorney,s_Creator,s_Editor,s_InRecycle,n_ModuleCheckStatusID,n_LatestCheckInfoID,n_AuthorID,n_CurCheckerID,s_TaskResult,n_MainCaseID,s_Category,s_RenewalDeadline)");
strSql.Append(" values (");
strSql.Append("@s_TaskType,@n_SysTaskCodeID,@n_EmployeeID,@s_TaskToEmail,@s_Level,@s_TaskName,@s_TaskDetail,@dt_AlarmDate,@dt_InterDeadline,@dt_ClientDeadline,@dt_OfficialDeadline,@dt_Deadline,@s_Status,@dt_StatusDate,@s_IsActive,@dt_CreateDate,@dt_EditDate,@n_FileID,@s_TaskTo,@n_CameFileID,@n_OutFileID,@n_FeeID,@n_BillID,@s_Applicants,@s_CaseSerial,@s_Country,@s_AppNo,@s_Introducer,@s_Attorney,@s_Creator,@s_Editor,@s_InRecycle,@n_ModuleCheckStatusID,@n_LatestCheckInfoID,@n_AuthorID,@n_CurCheckerID,@s_TaskResult,@n_MainCaseID,@s_Category,@s_RenewalDeadline)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@s_TaskType", SqlDbType.NVarChar, 50),
new SqlParameter("@n_SysTaskCodeID", SqlDbType.Int, 4),
new SqlParameter("@n_EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@s_TaskToEmail", SqlDbType.NVarChar, 300),
new SqlParameter("@s_Level", SqlDbType.NVarChar, 1),
new SqlParameter("@s_TaskName", SqlDbType.NVarChar, 300),
new SqlParameter("@s_TaskDetail", SqlDbType.NVarChar, 800),
new SqlParameter("@dt_AlarmDate", SqlDbType.DateTime),
new SqlParameter("@dt_InterDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_ClientDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_OfficialDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_Deadline", SqlDbType.DateTime),
new SqlParameter("@s_Status", SqlDbType.NVarChar, 1),
new SqlParameter("@dt_StatusDate", SqlDbType.DateTime),
new SqlParameter("@s_IsActive", SqlDbType.NVarChar, 1),
new SqlParameter("@dt_CreateDate", SqlDbType.DateTime),
new SqlParameter("@dt_EditDate", SqlDbType.DateTime),
new SqlParameter("@n_FileID", SqlDbType.Int, 4),
new SqlParameter("@s_TaskTo", SqlDbType.NVarChar, 50),
new SqlParameter("@n_CameFileID", SqlDbType.Int, 4),
new SqlParameter("@n_OutFileID", SqlDbType.Int, 4),
new SqlParameter("@n_FeeID", SqlDbType.Int, 4),
new SqlParameter("@n_BillID", SqlDbType.Int, 4),
new SqlParameter("@s_Applicants", SqlDbType.VarChar, 1000),
new SqlParameter("@s_CaseSerial", SqlDbType.VarChar, 100),
new SqlParameter("@s_Country", SqlDbType.VarChar, 100),
new SqlParameter("@s_AppNo", SqlDbType.VarChar, 100),
new SqlParameter("@s_Introducer", SqlDbType.VarChar, 300),
new SqlParameter("@s_Attorney", SqlDbType.VarChar, 200),
new SqlParameter("@s_Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@s_InRecycle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_ModuleCheckStatusID", SqlDbType.Int, 4),
new SqlParameter("@n_LatestCheckInfoID", SqlDbType.Int, 4),
new SqlParameter("@n_AuthorID", SqlDbType.Int, 4),
new SqlParameter("@n_CurCheckerID", SqlDbType.Int, 4),
new SqlParameter("@s_TaskResult", SqlDbType.NVarChar, 500),
new SqlParameter("@n_MainCaseID", SqlDbType.Int, 4),
new SqlParameter("@s_Category", SqlDbType.NVarChar, 100),
new SqlParameter("@s_RenewalDeadline", SqlDbType.NVarChar, 2)
};
parameters[0].Value = model.s_TaskType;
parameters[1].Value = model.n_SysTaskCodeID;
parameters[2].Value = model.n_EmployeeID;
parameters[3].Value = model.s_TaskToEmail;
parameters[4].Value = model.s_Level;
parameters[5].Value = model.s_TaskName;
parameters[6].Value = model.s_TaskDetail;
parameters[7].Value = model.dt_AlarmDate;
parameters[8].Value = model.dt_InterDeadline;
parameters[9].Value = model.dt_ClientDeadline;
parameters[10].Value = model.dt_OfficialDeadline;
parameters[11].Value = model.dt_Deadline;
parameters[12].Value = model.s_Status;
parameters[13].Value = model.dt_StatusDate;
parameters[14].Value = model.s_IsActive;
parameters[15].Value = model.dt_CreateDate;
parameters[16].Value = model.dt_EditDate;
parameters[17].Value = model.n_FileID;
parameters[18].Value = model.s_TaskTo;
parameters[19].Value = model.n_CameFileID;
parameters[20].Value = model.n_OutFileID;
parameters[21].Value = model.n_FeeID;
parameters[22].Value = model.n_BillID;
parameters[23].Value = model.s_Applicants;
parameters[24].Value = model.s_CaseSerial;
parameters[25].Value = model.s_Country;
parameters[26].Value = model.s_AppNo;
parameters[27].Value = model.s_Introducer;
parameters[28].Value = model.s_Attorney;
parameters[29].Value = model.s_Creator;
parameters[30].Value = model.s_Editor;
parameters[31].Value = model.s_InRecycle;
parameters[32].Value = model.n_ModuleCheckStatusID;
parameters[33].Value = model.n_LatestCheckInfoID;
parameters[34].Value = model.n_AuthorID;
parameters[35].Value = model.n_CurCheckerID;
parameters[36].Value = model.s_TaskResult;
parameters[37].Value = model.n_MainCaseID;
parameters[38].Value = model.s_Category;
parameters[39].Value = model.s_RenewalDeadline;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.T_Task DataRowToModel(DataRow row)
{
IPSP.Model.T_Task model = new IPSP.Model.T_Task();
if (row != null)
{
if (row["n_TaskID"] != null && row["n_TaskID"].ToString() != "")
{
model.n_TaskID = int.Parse(row["n_TaskID"].ToString());
}
if (row["s_TaskType"] != null)
{
model.s_TaskType = row["s_TaskType"].ToString();
}
if (row["n_SysTaskCodeID"] != null && row["n_SysTaskCodeID"].ToString() != "")
{
model.n_SysTaskCodeID = int.Parse(row["n_SysTaskCodeID"].ToString());
}
if (row["n_EmployeeID"] != null && row["n_EmployeeID"].ToString() != "")
{
model.n_EmployeeID = int.Parse(row["n_EmployeeID"].ToString());
}
if (row["s_TaskToEmail"] != null)
{
model.s_TaskToEmail = row["s_TaskToEmail"].ToString();
}
if (row["s_Level"] != null)
{
model.s_Level = row["s_Level"].ToString();
}
if (row["s_TaskName"] != null)
{
model.s_TaskName = row["s_TaskName"].ToString();
}
if (row["s_TaskDetail"] != null)
{
model.s_TaskDetail = row["s_TaskDetail"].ToString();
}
if (row["dt_AlarmDate"] != null && row["dt_AlarmDate"].ToString() != "")
{
model.dt_AlarmDate = DateTime.Parse(row["dt_AlarmDate"].ToString());
}
if (row["dt_InterDeadline"] != null && row["dt_InterDeadline"].ToString() != "")
{
model.dt_InterDeadline = DateTime.Parse(row["dt_InterDeadline"].ToString());
}
if (row["dt_ClientDeadline"] != null && row["dt_ClientDeadline"].ToString() != "")
{
model.dt_ClientDeadline = DateTime.Parse(row["dt_ClientDeadline"].ToString());
}
if (row["dt_OfficialDeadline"] != null && row["dt_OfficialDeadline"].ToString() != "")
{
model.dt_OfficialDeadline = DateTime.Parse(row["dt_OfficialDeadline"].ToString());
}
if (row["dt_Deadline"] != null && row["dt_Deadline"].ToString() != "")
{
model.dt_Deadline = DateTime.Parse(row["dt_Deadline"].ToString());
}
if (row["s_Status"] != null)
{
model.s_Status = row["s_Status"].ToString();
}
if (row["dt_StatusDate"] != null && row["dt_StatusDate"].ToString() != "")
{
model.dt_StatusDate = DateTime.Parse(row["dt_StatusDate"].ToString());
}
if (row["s_IsActive"] != null)
{
model.s_IsActive = row["s_IsActive"].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["n_FileID"] != null && row["n_FileID"].ToString() != "")
{
model.n_FileID = int.Parse(row["n_FileID"].ToString());
}
if (row["s_TaskTo"] != null)
{
model.s_TaskTo = row["s_TaskTo"].ToString();
}
if (row["n_CameFileID"] != null && row["n_CameFileID"].ToString() != "")
{
model.n_CameFileID = int.Parse(row["n_CameFileID"].ToString());
}
if (row["n_OutFileID"] != null && row["n_OutFileID"].ToString() != "")
{
model.n_OutFileID = int.Parse(row["n_OutFileID"].ToString());
}
if (row["n_FeeID"] != null && row["n_FeeID"].ToString() != "")
{
model.n_FeeID = int.Parse(row["n_FeeID"].ToString());
}
if (row["n_BillID"] != null && row["n_BillID"].ToString() != "")
{
model.n_BillID = int.Parse(row["n_BillID"].ToString());
}
if (row["s_Applicants"] != null)
{
model.s_Applicants = row["s_Applicants"].ToString();
}
if (row["s_CaseSerial"] != null)
{
model.s_CaseSerial = row["s_CaseSerial"].ToString();
}
if (row["s_Country"] != null)
{
model.s_Country = row["s_Country"].ToString();
}
if (row["s_AppNo"] != null)
{
model.s_AppNo = row["s_AppNo"].ToString();
}
if (row["s_Introducer"] != null)
{
model.s_Introducer = row["s_Introducer"].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["s_InRecycle"] != null)
{
model.s_InRecycle = row["s_InRecycle"].ToString();
}
if (row["n_ModuleCheckStatusID"] != null && row["n_ModuleCheckStatusID"].ToString() != "")
{
model.n_ModuleCheckStatusID = int.Parse(row["n_ModuleCheckStatusID"].ToString());
}
if (row["n_LatestCheckInfoID"] != null && row["n_LatestCheckInfoID"].ToString() != "")
{
model.n_LatestCheckInfoID = int.Parse(row["n_LatestCheckInfoID"].ToString());
}
if (row["n_AuthorID"] != null && row["n_AuthorID"].ToString() != "")
{
model.n_AuthorID = int.Parse(row["n_AuthorID"].ToString());
}
if (row["n_CurCheckerID"] != null && row["n_CurCheckerID"].ToString() != "")
{
model.n_CurCheckerID = int.Parse(row["n_CurCheckerID"].ToString());
}
if (row["s_TaskResult"] != null)
{
model.s_TaskResult = row["s_TaskResult"].ToString();
}
if (row["n_MainCaseID"] != null && row["n_MainCaseID"].ToString() != "")
{
model.n_MainCaseID = int.Parse(row["n_MainCaseID"].ToString());
}
if (row["s_Category"] != null)
{
model.s_Category = row["s_Category"].ToString();
}
if (row["s_RenewalDeadline"] != null)
{
model.s_RenewalDeadline = row["s_RenewalDeadline"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.T_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Task set ");
strSql.Append("s_TaskType=@s_TaskType,");
strSql.Append("n_SysTaskCodeID=@n_SysTaskCodeID,");
strSql.Append("n_EmployeeID=@n_EmployeeID,");
strSql.Append("s_TaskToEmail=@s_TaskToEmail,");
strSql.Append("s_Level=@s_Level,");
strSql.Append("s_TaskName=@s_TaskName,");
strSql.Append("s_TaskDetail=@s_TaskDetail,");
strSql.Append("dt_AlarmDate=@dt_AlarmDate,");
strSql.Append("dt_InterDeadline=@dt_InterDeadline,");
strSql.Append("dt_ClientDeadline=@dt_ClientDeadline,");
strSql.Append("dt_OfficialDeadline=@dt_OfficialDeadline,");
strSql.Append("dt_Deadline=@dt_Deadline,");
strSql.Append("s_Status=@s_Status,");
strSql.Append("dt_StatusDate=@dt_StatusDate,");
strSql.Append("s_IsActive=@s_IsActive,");
strSql.Append("dt_CreateDate=@dt_CreateDate,");
strSql.Append("dt_EditDate=@dt_EditDate,");
strSql.Append("s_TaskTo=@s_TaskTo,");
strSql.Append("n_CameFileID=@n_CameFileID,");
strSql.Append("s_Applicants=@s_Applicants,");
strSql.Append("s_CaseSerial=@s_CaseSerial,");
strSql.Append("s_Country=@s_Country,");
strSql.Append("s_AppNo=@s_AppNo,");
strSql.Append("s_Introducer=@s_Introducer,");
strSql.Append("s_Attorney=@s_Attorney,");
strSql.Append("s_Creator=@s_Creator,");
strSql.Append("s_Editor=@s_Editor,");
strSql.Append("s_InRecycle=@s_InRecycle,");
strSql.Append("n_ModuleCheckStatusID=@n_ModuleCheckStatusID,");
strSql.Append("n_LatestCheckInfoID=@n_LatestCheckInfoID,");
strSql.Append("n_AuthorID=@n_AuthorID,");
strSql.Append("n_CurCheckerID=@n_CurCheckerID,");
strSql.Append("s_TaskResult=@s_TaskResult,");
strSql.Append("n_MainCaseID=@n_MainCaseID,");
strSql.Append("s_Category=@s_Category,");
strSql.Append("s_RenewalDeadline=@s_RenewalDeadline");
strSql.Append(" where n_TaskID=@n_TaskID");
SqlParameter[] parameters =
{
new SqlParameter("@s_TaskType", SqlDbType.NVarChar, 50),
new SqlParameter("@n_SysTaskCodeID", SqlDbType.Int, 4),
new SqlParameter("@n_EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@s_TaskToEmail", SqlDbType.NVarChar, 300),
new SqlParameter("@s_Level", SqlDbType.NVarChar, 1),
new SqlParameter("@s_TaskName", SqlDbType.NVarChar, 300),
new SqlParameter("@s_TaskDetail", SqlDbType.NVarChar, 800),
new SqlParameter("@dt_AlarmDate", SqlDbType.DateTime),
new SqlParameter("@dt_InterDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_ClientDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_OfficialDeadline", SqlDbType.DateTime),
new SqlParameter("@dt_Deadline", SqlDbType.DateTime),
new SqlParameter("@s_Status", SqlDbType.NVarChar, 1),
new SqlParameter("@dt_StatusDate", SqlDbType.DateTime),
new SqlParameter("@s_IsActive", SqlDbType.NVarChar, 1),
new SqlParameter("@dt_CreateDate", SqlDbType.DateTime),
new SqlParameter("@dt_EditDate", SqlDbType.DateTime),
new SqlParameter("@s_TaskTo", SqlDbType.NVarChar, 50),
new SqlParameter("@n_CameFileID", SqlDbType.Int, 4),
new SqlParameter("@s_Applicants", SqlDbType.VarChar, 1000),
new SqlParameter("@s_CaseSerial", SqlDbType.VarChar, 100),
new SqlParameter("@s_Country", SqlDbType.VarChar, 100),
new SqlParameter("@s_AppNo", SqlDbType.VarChar, 100),
new SqlParameter("@s_Introducer", SqlDbType.VarChar, 300),
new SqlParameter("@s_Attorney", SqlDbType.VarChar, 200),
new SqlParameter("@s_Creator", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@s_InRecycle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_ModuleCheckStatusID", SqlDbType.Int, 4),
new SqlParameter("@n_LatestCheckInfoID", SqlDbType.Int, 4),
new SqlParameter("@n_AuthorID", SqlDbType.Int, 4),
new SqlParameter("@n_CurCheckerID", SqlDbType.Int, 4),
new SqlParameter("@s_TaskResult", SqlDbType.NVarChar, 500),
new SqlParameter("@n_MainCaseID", SqlDbType.Int, 4),
new SqlParameter("@s_Category", SqlDbType.NVarChar, 100),
new SqlParameter("@s_RenewalDeadline", SqlDbType.NVarChar, 2),
new SqlParameter("@n_TaskID", SqlDbType.Int, 4),
new SqlParameter("@n_FileID", SqlDbType.Int, 4),
new SqlParameter("@n_OutFileID", SqlDbType.Int, 4),
new SqlParameter("@n_FeeID", SqlDbType.Int, 4),
new SqlParameter("@n_BillID", SqlDbType.Int, 4)
};
parameters[0].Value = model.s_TaskType;
parameters[1].Value = model.n_SysTaskCodeID;
parameters[2].Value = model.n_EmployeeID;
parameters[3].Value = model.s_TaskToEmail;
parameters[4].Value = model.s_Level;
parameters[5].Value = model.s_TaskName;
parameters[6].Value = model.s_TaskDetail;
parameters[7].Value = model.dt_AlarmDate;
parameters[8].Value = model.dt_InterDeadline;
parameters[9].Value = model.dt_ClientDeadline;
parameters[10].Value = model.dt_OfficialDeadline;
parameters[11].Value = model.dt_Deadline;
parameters[12].Value = model.s_Status;
parameters[13].Value = model.dt_StatusDate;
parameters[14].Value = model.s_IsActive;
parameters[15].Value = model.dt_CreateDate;
parameters[16].Value = model.dt_EditDate;
parameters[17].Value = model.s_TaskTo;
parameters[18].Value = model.n_CameFileID;
parameters[19].Value = model.s_Applicants;
parameters[20].Value = model.s_CaseSerial;
parameters[21].Value = model.s_Country;
parameters[22].Value = model.s_AppNo;
parameters[23].Value = model.s_Introducer;
parameters[24].Value = model.s_Attorney;
parameters[25].Value = model.s_Creator;
parameters[26].Value = model.s_Editor;
parameters[27].Value = model.s_InRecycle;
parameters[28].Value = model.n_ModuleCheckStatusID;
parameters[29].Value = model.n_LatestCheckInfoID;
parameters[30].Value = model.n_AuthorID;
parameters[31].Value = model.n_CurCheckerID;
parameters[32].Value = model.s_TaskResult;
parameters[33].Value = model.n_MainCaseID;
parameters[34].Value = model.s_Category;
parameters[35].Value = model.s_RenewalDeadline;
parameters[36].Value = model.n_TaskID;
parameters[37].Value = model.n_FileID;
parameters[38].Value = model.n_OutFileID;
parameters[39].Value = model.n_FeeID;
parameters[40].Value = model.n_BillID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.T_Task model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.T_Task model)
{
return(dal.Add(model));
}
