/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TF_WorkItemInTaskChain GetModel(Guid g_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 g_ID,g_TaskChainGuid,n_CodeWorkItemID,s_Description,s_Note,n_RelatedFileID,n_EstimateValue,n_EstimateValueRecorder,s_EstimateValueNote,dt_EstimateValueTime,n_ActualValue,n_ActualValueRecorder,s_ActualValueNote,dt_ActualValueTime,n_Status,n_ActualServiceValue,n_HasCharge,dt_ChargeTime,n_ChargeRecorder,n_HasOfeeCharge,dt_OfeeChargeTime,n_OfeeChargeRecorder,g_TaskGuid from TF_WorkItemInTaskChain ");
strSql.Append(" where g_ID=@g_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@g_ID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = g_ID;
IPSP.Model.TF_WorkItemInTaskChain model = new IPSP.Model.TF_WorkItemInTaskChain();
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.TF_WorkItemInTaskChain model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IPSP.Model.TF_WorkItemInTaskChain model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IPSP.Model.TF_WorkItemInTaskChain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TF_WorkItemInTaskChain(");
strSql.Append("g_ID,g_TaskChainGuid,n_CodeWorkItemID,s_Description,s_Note,n_RelatedFileID,n_EstimateValue,n_EstimateValueRecorder,s_EstimateValueNote,dt_EstimateValueTime,n_ActualValue,n_ActualValueRecorder,s_ActualValueNote,dt_ActualValueTime,n_Status,n_ActualServiceValue,n_HasCharge,dt_ChargeTime,n_ChargeRecorder,n_HasOfeeCharge,dt_OfeeChargeTime,n_OfeeChargeRecorder,g_TaskGuid)");
strSql.Append(" values (");
strSql.Append("@g_ID,@g_TaskChainGuid,@n_CodeWorkItemID,@s_Description,@s_Note,@n_RelatedFileID,@n_EstimateValue,@n_EstimateValueRecorder,@s_EstimateValueNote,@dt_EstimateValueTime,@n_ActualValue,@n_ActualValueRecorder,@s_ActualValueNote,@dt_ActualValueTime,@n_Status,@n_ActualServiceValue,@n_HasCharge,@dt_ChargeTime,@n_ChargeRecorder,@n_HasOfeeCharge,@dt_OfeeChargeTime,@n_OfeeChargeRecorder,@g_TaskGuid)");
SqlParameter[] parameters =
{
new SqlParameter("@g_ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@g_TaskChainGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@n_CodeWorkItemID", SqlDbType.Int, 4),
new SqlParameter("@s_Description", SqlDbType.NVarChar, 1000),
new SqlParameter("@s_Note", SqlDbType.NVarChar, 1000),
new SqlParameter("@n_RelatedFileID", SqlDbType.Int, 4),
new SqlParameter("@n_EstimateValue", SqlDbType.Decimal, 5),
new SqlParameter("@n_EstimateValueRecorder", SqlDbType.Int, 4),
new SqlParameter("@s_EstimateValueNote", SqlDbType.NVarChar, 1000),
new SqlParameter("@dt_EstimateValueTime", SqlDbType.DateTime),
new SqlParameter("@n_ActualValue", SqlDbType.Decimal, 5),
new SqlParameter("@n_ActualValueRecorder", SqlDbType.Int, 4),
new SqlParameter("@s_ActualValueNote", SqlDbType.NVarChar, 1000),
new SqlParameter("@dt_ActualValueTime", SqlDbType.DateTime),
new SqlParameter("@n_Status", SqlDbType.Int, 4),
new SqlParameter("@n_ActualServiceValue", SqlDbType.Decimal, 9),
new SqlParameter("@n_HasCharge", SqlDbType.Int, 4),
new SqlParameter("@dt_ChargeTime", SqlDbType.DateTime),
new SqlParameter("@n_ChargeRecorder", SqlDbType.Int, 4),
new SqlParameter("@n_HasOfeeCharge", SqlDbType.Int, 4),
new SqlParameter("@dt_OfeeChargeTime", SqlDbType.DateTime),
new SqlParameter("@n_OfeeChargeRecorder", SqlDbType.Int, 4),
new SqlParameter("@g_TaskGuid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.n_CodeWorkItemID;
parameters[3].Value = model.s_Description;
parameters[4].Value = model.s_Note;
parameters[5].Value = model.n_RelatedFileID;
parameters[6].Value = model.n_EstimateValue;
parameters[7].Value = model.n_EstimateValueRecorder;
parameters[8].Value = model.s_EstimateValueNote;
parameters[9].Value = model.dt_EstimateValueTime;
parameters[10].Value = model.n_ActualValue;
parameters[11].Value = model.n_ActualValueRecorder;
parameters[12].Value = model.s_ActualValueNote;
parameters[13].Value = model.dt_ActualValueTime;
parameters[14].Value = model.n_Status;
parameters[15].Value = model.n_ActualServiceValue;
parameters[16].Value = model.n_HasCharge;
parameters[17].Value = model.dt_ChargeTime;
parameters[18].Value = model.n_ChargeRecorder;
parameters[19].Value = model.n_HasOfeeCharge;
parameters[20].Value = model.dt_OfeeChargeTime;
parameters[21].Value = model.n_OfeeChargeRecorder;
parameters[22].Value = Guid.NewGuid();
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TF_WorkItemInTaskChain DataRowToModel(DataRow row)
{
IPSP.Model.TF_WorkItemInTaskChain model = new IPSP.Model.TF_WorkItemInTaskChain();
if (row != null)
{
if (row["g_ID"] != null && row["g_ID"].ToString() != "")
{
model.g_ID = new Guid(row["g_ID"].ToString());
}
if (row["g_TaskChainGuid"] != null && row["g_TaskChainGuid"].ToString() != "")
{
model.g_TaskChainGuid = new Guid(row["g_TaskChainGuid"].ToString());
}
if (row["n_CodeWorkItemID"] != null && row["n_CodeWorkItemID"].ToString() != "")
{
model.n_CodeWorkItemID = int.Parse(row["n_CodeWorkItemID"].ToString());
}
if (row["s_Description"] != null)
{
model.s_Description = row["s_Description"].ToString();
}
if (row["s_Note"] != null)
{
model.s_Note = row["s_Note"].ToString();
}
if (row["n_RelatedFileID"] != null && row["n_RelatedFileID"].ToString() != "")
{
model.n_RelatedFileID = int.Parse(row["n_RelatedFileID"].ToString());
}
if (row["n_EstimateValue"] != null && row["n_EstimateValue"].ToString() != "")
{
model.n_EstimateValue = decimal.Parse(row["n_EstimateValue"].ToString());
}
if (row["n_EstimateValueRecorder"] != null && row["n_EstimateValueRecorder"].ToString() != "")
{
model.n_EstimateValueRecorder = int.Parse(row["n_EstimateValueRecorder"].ToString());
}
if (row["s_EstimateValueNote"] != null)
{
model.s_EstimateValueNote = row["s_EstimateValueNote"].ToString();
}
if (row["dt_EstimateValueTime"] != null && row["dt_EstimateValueTime"].ToString() != "")
{
model.dt_EstimateValueTime = DateTime.Parse(row["dt_EstimateValueTime"].ToString());
}
if (row["n_ActualValue"] != null && row["n_ActualValue"].ToString() != "")
{
model.n_ActualValue = decimal.Parse(row["n_ActualValue"].ToString());
}
if (row["n_ActualValueRecorder"] != null && row["n_ActualValueRecorder"].ToString() != "")
{
model.n_ActualValueRecorder = int.Parse(row["n_ActualValueRecorder"].ToString());
}
if (row["s_ActualValueNote"] != null)
{
model.s_ActualValueNote = row["s_ActualValueNote"].ToString();
}
if (row["dt_ActualValueTime"] != null && row["dt_ActualValueTime"].ToString() != "")
{
model.dt_ActualValueTime = DateTime.Parse(row["dt_ActualValueTime"].ToString());
}
if (row["n_Status"] != null && row["n_Status"].ToString() != "")
{
model.n_Status = int.Parse(row["n_Status"].ToString());
}
if (row["n_ActualServiceValue"] != null && row["n_ActualServiceValue"].ToString() != "")
{
model.n_ActualServiceValue = decimal.Parse(row["n_ActualServiceValue"].ToString());
}
if (row["n_HasCharge"] != null && row["n_HasCharge"].ToString() != "")
{
model.n_HasCharge = int.Parse(row["n_HasCharge"].ToString());
}
if (row["dt_ChargeTime"] != null && row["dt_ChargeTime"].ToString() != "")
{
model.dt_ChargeTime = DateTime.Parse(row["dt_ChargeTime"].ToString());
}
if (row["n_ChargeRecorder"] != null && row["n_ChargeRecorder"].ToString() != "")
{
model.n_ChargeRecorder = int.Parse(row["n_ChargeRecorder"].ToString());
}
if (row["n_HasOfeeCharge"] != null && row["n_HasOfeeCharge"].ToString() != "")
{
model.n_HasOfeeCharge = int.Parse(row["n_HasOfeeCharge"].ToString());
}
if (row["dt_OfeeChargeTime"] != null && row["dt_OfeeChargeTime"].ToString() != "")
{
model.dt_OfeeChargeTime = DateTime.Parse(row["dt_OfeeChargeTime"].ToString());
}
if (row["n_OfeeChargeRecorder"] != null && row["n_OfeeChargeRecorder"].ToString() != "")
{
model.n_OfeeChargeRecorder = int.Parse(row["n_OfeeChargeRecorder"].ToString());
}
if (row["g_TaskGuid"] != null && row["g_TaskGuid"].ToString() != "")
{
model.g_TaskGuid = new Guid(row["g_TaskGuid"].ToString());
}
}
return(model);
}
