public List <PayoutTargetModel> GetListArray(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select TargetId,ContractId,TaskId,SignAMount from Con_Payout_Target ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
List <PayoutTargetModel> list = new List <PayoutTargetModel>();
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[0]))
{
while (reader.Read())
{
PayoutTargetModel item = null;
item.Id = reader["TargetId"].ToString();
item.ContractId = reader["ContractId"].ToString();
item.taskId = reader["TaskId"].ToString();
item.SignAmount = new decimal?(Convert.ToDecimal(reader["SignAMount"]));
list.Add(item);
}
}
return(list);
}
public int Update(PayoutTargetModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Con_Payout_Target set ");
builder.Append("ContractId=@ContractId,");
builder.Append("TaskId=@TaskId,");
builder.Append("SignAMount=@SignAMount ");
builder.Append(" where TargetId=@ID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 500), new SqlParameter("@ContractId", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaskId", SqlDbType.NVarChar, 500), new SqlParameter("@SignAMount", SqlDbType.Decimal, 0x12) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.ContractId;
commandParameters[2].Value = model.TaskId;
commandParameters[3].Value = model.SignAmount;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public PayoutTargetModel GetModel(string id)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ContractId,TaskId,SignAMount from Con_Payout_Target ");
builder.Append(" where TargetId=@ID ");
PayoutTargetModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@ID", id) }))
{
if (reader.Read())
{
model.Id = id;
model.ContractId = reader["ContractId"].ToString();
model.taskId = reader["TaskId"].ToString();
model.SignAmount = new decimal?(Convert.ToDecimal(reader["SignAMount"]));
}
}
return(model);
}
private void Add(SqlTransaction trans, PayoutTargetModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Con_Payout_Target(");
builder.Append("TargetId,ContractId,TaskId,SignAMount)");
builder.Append(" values (");
builder.Append("@ID,@ContractId,@TaskId,@SignAMount)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 500), new SqlParameter("@ContractId", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaskId", SqlDbType.NVarChar, 500), new SqlParameter("@SignAMount", SqlDbType.Decimal, 0x12) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.ContractId;
commandParameters[2].Value = model.TaskId;
commandParameters[3].Value = model.SignAmount;
if (trans == null)
{
SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters);
}
else
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters);
}
}
public void Update(PayoutTargetModel model)
{
this.payment.Update(model);
}
