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); }