/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Para_JobType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Para_JobType set ");
strSql.Append("JobTypeParent=@JobTypeParent,");
strSql.Append("JobName=@JobName,");
strSql.Append("JobDbName=@JobDbName,");
strSql.Append("WorkDay=@WorkDay,");
strSql.Append("HandlingFee=@HandlingFee,");
strSql.Append("CostFee=@CostFee");
strSql.Append("CardType=@CardType");
strSql.Append(" where JobTypeID=@JobTypeID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeParent", SqlDbType.NVarChar, 8),
new SqlParameter("@JobName", SqlDbType.NVarChar, 64),
new SqlParameter("@JobDbName", SqlDbType.NVarChar, 64),
new SqlParameter("@WorkDay", SqlDbType.Int, 4),
new SqlParameter("@HandlingFee", SqlDbType.Float, 8),
new SqlParameter("@CostFee", SqlDbType.Float, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64),
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8)
};
parameters[0].Value = model.JobTypeParent;
parameters[1].Value = model.JobName;
parameters[2].Value = model.JobDbName;
parameters[3].Value = model.WorkDay;
parameters[4].Value = model.HandlingFee;
parameters[5].Value = model.CostFee;
parameters[6].Value = model.CardType;
parameters[7].Value = model.JobTypeID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Para_JobType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Para_JobType(");
strSql.Append("JobTypeID,JobTypeParent,JobName,JobDbName,WorkDay,HandlingFee,CostFee,CardType)");
strSql.Append(" values (");
strSql.Append("@JobTypeID,@JobTypeParent,@JobName,@JobDbName,@WorkDay,@HandlingFee,@CostFee,@CardType)");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8),
new SqlParameter("@JobTypeParent", SqlDbType.NVarChar, 8),
new SqlParameter("@JobName", SqlDbType.NVarChar, 64),
new SqlParameter("@JobDbName", SqlDbType.NVarChar, 64),
new SqlParameter("@WorkDay", SqlDbType.Int, 4),
new SqlParameter("@HandlingFee", SqlDbType.Float, 8),
new SqlParameter("@CostFee", SqlDbType.Float, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobTypeID;
parameters[1].Value = model.JobTypeParent;
parameters[2].Value = model.JobName;
parameters[3].Value = model.JobDbName;
parameters[4].Value = model.WorkDay;
parameters[5].Value = model.HandlingFee;
parameters[6].Value = model.CostFee;
parameters[7].Value = model.CardType;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CardCenter.Entity.Para_JobType DataRowToModel(DataRow row)
{
CardCenter.Entity.Para_JobType model = new CardCenter.Entity.Para_JobType();
if (row != null)
{
if (row["JobTypeID"] != null)
{
model.JobTypeID = row["JobTypeID"].ToString();
}
if (row["JobTypeParent"] != null)
{
model.JobTypeParent = row["JobTypeParent"].ToString();
}
if (row["JobName"] != null)
{
model.JobName = row["JobName"].ToString();
}
if (row["JobDbName"] != null)
{
model.JobDbName = row["JobDbName"].ToString();
}
if (row["WorkDay"] != null && row["WorkDay"].ToString() != "")
{
model.WorkDay = int.Parse(row["WorkDay"].ToString());
}
if (row["HandlingFee"] != null && row["HandlingFee"].ToString() != "")
{
model.HandlingFee = decimal.Parse(row["HandlingFee"].ToString());
}
if (row["CostFee"] != null && row["CostFee"].ToString() != "")
{
model.CostFee = decimal.Parse(row["CostFee"].ToString());
}
if (row["CardType"] != null)
{
model.CardType = row["CardType"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CardCenter.Entity.Para_JobType GetModel(string JobTypeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JobTypeID,JobTypeParent,JobName,JobDbName,WorkDay,HandlingFee,CostFee,CardType from Para_JobType ");
strSql.Append(" where JobTypeID=@JobTypeID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8)
};
parameters[0].Value = JobTypeID;
CardCenter.Entity.Para_JobType model = new CardCenter.Entity.Para_JobType();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
