/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TFCode_Task GetModel(Guid g_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 g_ID,s_Name,s_Description,n_TaskTypeID,n_DemandTypeID,n_Level,s_ExecutorType,s_ExecutorValue,s_FinishCondition,s_StartDateCalcRule,s_StartDateTaskCode,s_StartDateTaskDateType,g_StartCodeDeadlineGuid,n_StartDateValue1,s_StartDateType1,n_StartDateValue2,s_StartDateType2,s_EndDateCalcRule,s_EndDateTaskCode,s_EndDateTaskDateType,g_EndCodeDeadlineGuid,n_EndDateValue1,s_EndDateType1,n_EndDateValue2,s_EndDateType2,g_EndFinallyCodeDeadlineGuid from TFCode_Task ");
strSql.Append(" where g_ID=@g_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@g_ID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = g_ID;
IPSP.Model.TFCode_Task model = new IPSP.Model.TFCode_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 bool Add(IPSP.Model.TFCode_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TFCode_Task(");
strSql.Append("g_ID,s_Name,s_Description,n_TaskTypeID,n_DemandTypeID,n_Level,s_ExecutorType,s_ExecutorValue,s_FinishCondition,s_StartDateCalcRule,s_StartDateTaskCode,s_StartDateTaskDateType,g_StartCodeDeadlineGuid,n_StartDateValue1,s_StartDateType1,n_StartDateValue2,s_StartDateType2,s_EndDateCalcRule,s_EndDateTaskCode,s_EndDateTaskDateType,g_EndCodeDeadlineGuid,n_EndDateValue1,s_EndDateType1,n_EndDateValue2,s_EndDateType2,g_EndFinallyCodeDeadlineGuid)");
strSql.Append(" values (");
strSql.Append("@g_ID,@s_Name,@s_Description,@n_TaskTypeID,@n_DemandTypeID,@n_Level,@s_ExecutorType,@s_ExecutorValue,@s_FinishCondition,@s_StartDateCalcRule,@s_StartDateTaskCode,@s_StartDateTaskDateType,@g_StartCodeDeadlineGuid,@n_StartDateValue1,@s_StartDateType1,@n_StartDateValue2,@s_StartDateType2,@s_EndDateCalcRule,@s_EndDateTaskCode,@s_EndDateTaskDateType,@g_EndCodeDeadlineGuid,@n_EndDateValue1,@s_EndDateType1,@n_EndDateValue2,@s_EndDateType2,@g_EndFinallyCodeDeadlineGuid)");
SqlParameter[] parameters =
{
new SqlParameter("@g_ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@s_Name", SqlDbType.NVarChar, 300),
new SqlParameter("@s_Description", SqlDbType.NVarChar, 500),
new SqlParameter("@n_TaskTypeID", SqlDbType.Int, 4),
new SqlParameter("@n_DemandTypeID", SqlDbType.Int, 4),
new SqlParameter("@n_Level", SqlDbType.Int, 4),
new SqlParameter("@s_ExecutorType", SqlDbType.NVarChar, 1),
new SqlParameter("@s_ExecutorValue", SqlDbType.NVarChar, 500),
new SqlParameter("@s_FinishCondition", SqlDbType.NVarChar, 2000),
new SqlParameter("@s_StartDateCalcRule", SqlDbType.NVarChar, 50),
new SqlParameter("@s_StartDateTaskCode", SqlDbType.NVarChar, 21),
new SqlParameter("@s_StartDateTaskDateType", SqlDbType.NVarChar, 50),
new SqlParameter("@g_StartCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@n_StartDateValue1", SqlDbType.Int, 4),
new SqlParameter("@s_StartDateType1", SqlDbType.NVarChar, 50),
new SqlParameter("@n_StartDateValue2", SqlDbType.Int, 4),
new SqlParameter("@s_StartDateType2", SqlDbType.NVarChar, 50),
new SqlParameter("@s_EndDateCalcRule", SqlDbType.NVarChar, 50),
new SqlParameter("@s_EndDateTaskCode", SqlDbType.NVarChar, 21),
new SqlParameter("@s_EndDateTaskDateType", SqlDbType.NVarChar, 50),
new SqlParameter("@g_EndCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@n_EndDateValue1", SqlDbType.Int, 4),
new SqlParameter("@s_EndDateType1", SqlDbType.NVarChar, 50),
new SqlParameter("@n_EndDateValue2", SqlDbType.Int, 4),
new SqlParameter("@s_EndDateType2", SqlDbType.NVarChar, 50),
new SqlParameter("@g_EndFinallyCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.s_Name;
parameters[2].Value = model.s_Description;
parameters[3].Value = model.n_TaskTypeID;
parameters[4].Value = model.n_DemandTypeID;
parameters[5].Value = model.n_Level;
parameters[6].Value = model.s_ExecutorType;
parameters[7].Value = model.s_ExecutorValue;
parameters[8].Value = model.s_FinishCondition;
parameters[9].Value = model.s_StartDateCalcRule;
parameters[10].Value = model.s_StartDateTaskCode;
parameters[11].Value = model.s_StartDateTaskDateType;
parameters[12].Value = Guid.NewGuid();
parameters[13].Value = model.n_StartDateValue1;
parameters[14].Value = model.s_StartDateType1;
parameters[15].Value = model.n_StartDateValue2;
parameters[16].Value = model.s_StartDateType2;
parameters[17].Value = model.s_EndDateCalcRule;
parameters[18].Value = model.s_EndDateTaskCode;
parameters[19].Value = model.s_EndDateTaskDateType;
parameters[20].Value = Guid.NewGuid();
parameters[21].Value = model.n_EndDateValue1;
parameters[22].Value = model.s_EndDateType1;
parameters[23].Value = model.n_EndDateValue2;
parameters[24].Value = model.s_EndDateType2;
parameters[25].Value = Guid.NewGuid();
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TFCode_Task DataRowToModel(DataRow row)
{
IPSP.Model.TFCode_Task model = new IPSP.Model.TFCode_Task();
if (row != null)
{
if (row["g_ID"] != null && row["g_ID"].ToString() != "")
{
model.g_ID = new Guid(row["g_ID"].ToString());
}
if (row["s_Name"] != null)
{
model.s_Name = row["s_Name"].ToString();
}
if (row["s_Description"] != null)
{
model.s_Description = row["s_Description"].ToString();
}
if (row["n_TaskTypeID"] != null && row["n_TaskTypeID"].ToString() != "")
{
model.n_TaskTypeID = int.Parse(row["n_TaskTypeID"].ToString());
}
if (row["n_DemandTypeID"] != null && row["n_DemandTypeID"].ToString() != "")
{
model.n_DemandTypeID = int.Parse(row["n_DemandTypeID"].ToString());
}
if (row["n_Level"] != null && row["n_Level"].ToString() != "")
{
model.n_Level = int.Parse(row["n_Level"].ToString());
}
if (row["s_ExecutorType"] != null)
{
model.s_ExecutorType = row["s_ExecutorType"].ToString();
}
if (row["s_ExecutorValue"] != null)
{
model.s_ExecutorValue = row["s_ExecutorValue"].ToString();
}
if (row["s_FinishCondition"] != null)
{
model.s_FinishCondition = row["s_FinishCondition"].ToString();
}
if (row["s_StartDateCalcRule"] != null)
{
model.s_StartDateCalcRule = row["s_StartDateCalcRule"].ToString();
}
if (row["s_StartDateTaskCode"] != null)
{
model.s_StartDateTaskCode = row["s_StartDateTaskCode"].ToString();
}
if (row["s_StartDateTaskDateType"] != null)
{
model.s_StartDateTaskDateType = row["s_StartDateTaskDateType"].ToString();
}
if (row["g_StartCodeDeadlineGuid"] != null && row["g_StartCodeDeadlineGuid"].ToString() != "")
{
model.g_StartCodeDeadlineGuid = new Guid(row["g_StartCodeDeadlineGuid"].ToString());
}
if (row["n_StartDateValue1"] != null && row["n_StartDateValue1"].ToString() != "")
{
model.n_StartDateValue1 = int.Parse(row["n_StartDateValue1"].ToString());
}
if (row["s_StartDateType1"] != null)
{
model.s_StartDateType1 = row["s_StartDateType1"].ToString();
}
if (row["n_StartDateValue2"] != null && row["n_StartDateValue2"].ToString() != "")
{
model.n_StartDateValue2 = int.Parse(row["n_StartDateValue2"].ToString());
}
if (row["s_StartDateType2"] != null)
{
model.s_StartDateType2 = row["s_StartDateType2"].ToString();
}
if (row["s_EndDateCalcRule"] != null)
{
model.s_EndDateCalcRule = row["s_EndDateCalcRule"].ToString();
}
if (row["s_EndDateTaskCode"] != null)
{
model.s_EndDateTaskCode = row["s_EndDateTaskCode"].ToString();
}
if (row["s_EndDateTaskDateType"] != null)
{
model.s_EndDateTaskDateType = row["s_EndDateTaskDateType"].ToString();
}
if (row["g_EndCodeDeadlineGuid"] != null && row["g_EndCodeDeadlineGuid"].ToString() != "")
{
model.g_EndCodeDeadlineGuid = new Guid(row["g_EndCodeDeadlineGuid"].ToString());
}
if (row["n_EndDateValue1"] != null && row["n_EndDateValue1"].ToString() != "")
{
model.n_EndDateValue1 = int.Parse(row["n_EndDateValue1"].ToString());
}
if (row["s_EndDateType1"] != null)
{
model.s_EndDateType1 = row["s_EndDateType1"].ToString();
}
if (row["n_EndDateValue2"] != null && row["n_EndDateValue2"].ToString() != "")
{
model.n_EndDateValue2 = int.Parse(row["n_EndDateValue2"].ToString());
}
if (row["s_EndDateType2"] != null)
{
model.s_EndDateType2 = row["s_EndDateType2"].ToString();
}
if (row["g_EndFinallyCodeDeadlineGuid"] != null && row["g_EndFinallyCodeDeadlineGuid"].ToString() != "")
{
model.g_EndFinallyCodeDeadlineGuid = new Guid(row["g_EndFinallyCodeDeadlineGuid"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TFCode_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TFCode_Task set ");
strSql.Append("s_Name=@s_Name,");
strSql.Append("s_Description=@s_Description,");
strSql.Append("n_TaskTypeID=@n_TaskTypeID,");
strSql.Append("n_DemandTypeID=@n_DemandTypeID,");
strSql.Append("n_Level=@n_Level,");
strSql.Append("s_ExecutorType=@s_ExecutorType,");
strSql.Append("s_ExecutorValue=@s_ExecutorValue,");
strSql.Append("s_FinishCondition=@s_FinishCondition,");
strSql.Append("s_StartDateCalcRule=@s_StartDateCalcRule,");
strSql.Append("s_StartDateTaskCode=@s_StartDateTaskCode,");
strSql.Append("s_StartDateTaskDateType=@s_StartDateTaskDateType,");
strSql.Append("g_StartCodeDeadlineGuid=@g_StartCodeDeadlineGuid,");
strSql.Append("n_StartDateValue1=@n_StartDateValue1,");
strSql.Append("s_StartDateType1=@s_StartDateType1,");
strSql.Append("n_StartDateValue2=@n_StartDateValue2,");
strSql.Append("s_StartDateType2=@s_StartDateType2,");
strSql.Append("s_EndDateCalcRule=@s_EndDateCalcRule,");
strSql.Append("s_EndDateTaskCode=@s_EndDateTaskCode,");
strSql.Append("s_EndDateTaskDateType=@s_EndDateTaskDateType,");
strSql.Append("g_EndCodeDeadlineGuid=@g_EndCodeDeadlineGuid,");
strSql.Append("n_EndDateValue1=@n_EndDateValue1,");
strSql.Append("s_EndDateType1=@s_EndDateType1,");
strSql.Append("n_EndDateValue2=@n_EndDateValue2,");
strSql.Append("s_EndDateType2=@s_EndDateType2,");
strSql.Append("g_EndFinallyCodeDeadlineGuid=@g_EndFinallyCodeDeadlineGuid");
strSql.Append(" where g_ID=@g_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@s_Name", SqlDbType.NVarChar, 300),
new SqlParameter("@s_Description", SqlDbType.NVarChar, 500),
new SqlParameter("@n_TaskTypeID", SqlDbType.Int, 4),
new SqlParameter("@n_DemandTypeID", SqlDbType.Int, 4),
new SqlParameter("@n_Level", SqlDbType.Int, 4),
new SqlParameter("@s_ExecutorType", SqlDbType.NVarChar, 1),
new SqlParameter("@s_ExecutorValue", SqlDbType.NVarChar, 500),
new SqlParameter("@s_FinishCondition", SqlDbType.NVarChar, 2000),
new SqlParameter("@s_StartDateCalcRule", SqlDbType.NVarChar, 50),
new SqlParameter("@s_StartDateTaskCode", SqlDbType.NVarChar, 21),
new SqlParameter("@s_StartDateTaskDateType", SqlDbType.NVarChar, 50),
new SqlParameter("@g_StartCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@n_StartDateValue1", SqlDbType.Int, 4),
new SqlParameter("@s_StartDateType1", SqlDbType.NVarChar, 50),
new SqlParameter("@n_StartDateValue2", SqlDbType.Int, 4),
new SqlParameter("@s_StartDateType2", SqlDbType.NVarChar, 50),
new SqlParameter("@s_EndDateCalcRule", SqlDbType.NVarChar, 50),
new SqlParameter("@s_EndDateTaskCode", SqlDbType.NVarChar, 21),
new SqlParameter("@s_EndDateTaskDateType", SqlDbType.NVarChar, 50),
new SqlParameter("@g_EndCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@n_EndDateValue1", SqlDbType.Int, 4),
new SqlParameter("@s_EndDateType1", SqlDbType.NVarChar, 50),
new SqlParameter("@n_EndDateValue2", SqlDbType.Int, 4),
new SqlParameter("@s_EndDateType2", SqlDbType.NVarChar, 50),
new SqlParameter("@g_EndFinallyCodeDeadlineGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@g_ID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = model.s_Name;
parameters[1].Value = model.s_Description;
parameters[2].Value = model.n_TaskTypeID;
parameters[3].Value = model.n_DemandTypeID;
parameters[4].Value = model.n_Level;
parameters[5].Value = model.s_ExecutorType;
parameters[6].Value = model.s_ExecutorValue;
parameters[7].Value = model.s_FinishCondition;
parameters[8].Value = model.s_StartDateCalcRule;
parameters[9].Value = model.s_StartDateTaskCode;
parameters[10].Value = model.s_StartDateTaskDateType;
parameters[11].Value = model.g_StartCodeDeadlineGuid;
parameters[12].Value = model.n_StartDateValue1;
parameters[13].Value = model.s_StartDateType1;
parameters[14].Value = model.n_StartDateValue2;
parameters[15].Value = model.s_StartDateType2;
parameters[16].Value = model.s_EndDateCalcRule;
parameters[17].Value = model.s_EndDateTaskCode;
parameters[18].Value = model.s_EndDateTaskDateType;
parameters[19].Value = model.g_EndCodeDeadlineGuid;
parameters[20].Value = model.n_EndDateValue1;
parameters[21].Value = model.s_EndDateType1;
parameters[22].Value = model.n_EndDateValue2;
parameters[23].Value = model.s_EndDateType2;
parameters[24].Value = model.g_EndFinallyCodeDeadlineGuid;
parameters[25].Value = model.g_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TFCode_Task model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IPSP.Model.TFCode_Task model)
{
return(dal.Add(model));
}
