public int Add(TaxStartPointModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SaM_IncomeTax(");
builder.Append("TaxRateID,TaxStartPoint,LowerLimit,UpperLimit,TaxRate,Deduct,AddDate)");
builder.Append(" values (");
builder.Append("@TaxRateID,@TaxStartPoint,@LowerLimit,@UpperLimit,@TaxRate,@Deduct,@AddDate)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@TaxRateID", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaxStartPoint", SqlDbType.Decimal, 9), new SqlParameter("@LowerLimit", SqlDbType.Decimal, 9), new SqlParameter("@UpperLimit", SqlDbType.Decimal, 9), new SqlParameter("@TaxRate", SqlDbType.Decimal, 9), new SqlParameter("@Deduct", SqlDbType.Decimal, 9), new SqlParameter("@AddDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.TaxRateID;
commandParameters[1].Value = model.TaxStartPoint;
commandParameters[2].Value = model.LowerLimit;
commandParameters[3].Value = model.UpperLimit;
commandParameters[4].Value = model.TaxRate;
commandParameters[5].Value = model.Deduct;
commandParameters[6].Value = model.AddDate;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public TaxStartPointModel GetModel(string TaxRateID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 TaxRateID,TaxStartPoint,LowerLimit,UpperLimit,TaxRate,Deduct,AddDate from SaM_IncomeTax ");
builder.Append(" where TaxRateID=@TaxRateID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@TaxRateID", SqlDbType.NVarChar, 50) };
commandParameters[0].Value = TaxRateID;
TaxStartPointModel model = new TaxStartPointModel();
DataTable table = SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), commandParameters);
if (table.Rows.Count <= 0)
{
return(null);
}
model.TaxRateID = table.Rows[0]["TaxRateID"].ToString();
if (table.Rows[0]["TaxStartPoint"].ToString() != "")
{
model.TaxStartPoint = decimal.Parse(table.Rows[0]["TaxStartPoint"].ToString());
}
if (table.Rows[0]["LowerLimit"].ToString() != "")
{
model.LowerLimit = decimal.Parse(table.Rows[0]["LowerLimit"].ToString());
}
if (table.Rows[0]["UpperLimit"].ToString() != "")
{
model.UpperLimit = decimal.Parse(table.Rows[0]["UpperLimit"].ToString());
}
if (table.Rows[0]["TaxRate"].ToString() != "")
{
model.TaxRate = decimal.Parse(table.Rows[0]["TaxRate"].ToString());
}
if (table.Rows[0]["Deduct"].ToString() != "")
{
model.Deduct = new decimal?(decimal.Parse(table.Rows[0]["Deduct"].ToString()));
}
if (table.Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = new DateTime?(DateTime.Parse(table.Rows[0]["AddDate"].ToString()));
}
return(model);
}
public List <TaxStartPointModel> DataTableToList(DataTable dt)
{
List <TaxStartPointModel> list = new List <TaxStartPointModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
TaxStartPointModel item = new TaxStartPointModel {
TaxRateID = dt.Rows[i]["TaxRateID"].ToString()
};
if (dt.Rows[i]["TaxStartPoint"].ToString() != "")
{
item.TaxStartPoint = decimal.Parse(dt.Rows[i]["TaxStartPoint"].ToString());
}
if (dt.Rows[i]["LowerLimit"].ToString() != "")
{
item.LowerLimit = decimal.Parse(dt.Rows[i]["LowerLimit"].ToString());
}
if (dt.Rows[i]["UpperLimit"].ToString() != "")
{
item.UpperLimit = decimal.Parse(dt.Rows[i]["UpperLimit"].ToString());
}
if (dt.Rows[i]["TaxRate"].ToString() != "")
{
item.TaxRate = decimal.Parse(dt.Rows[i]["TaxRate"].ToString());
}
if (dt.Rows[i]["Deduct"].ToString() != "")
{
item.Deduct = new decimal?(decimal.Parse(dt.Rows[i]["Deduct"].ToString()));
}
if (dt.Rows[i]["AddDate"].ToString() != "")
{
item.AddDate = new DateTime?(DateTime.Parse(dt.Rows[i]["AddDate"].ToString()));
}
list.Add(item);
}
}
return(list);
}
public int Update(TaxStartPointModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SaM_IncomeTax set ");
builder.Append("TaxStartPoint=@TaxStartPoint,");
builder.Append("LowerLimit=@LowerLimit,");
builder.Append("UpperLimit=@UpperLimit,");
builder.Append("TaxRate=@TaxRate,");
builder.Append("Deduct=@Deduct,");
builder.Append("AddDate=@AddDate");
builder.Append(" where TaxRateID=@TaxRateID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@TaxRateID", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaxStartPoint", SqlDbType.Decimal, 9), new SqlParameter("@LowerLimit", SqlDbType.Decimal, 9), new SqlParameter("@UpperLimit", SqlDbType.Decimal, 9), new SqlParameter("@TaxRate", SqlDbType.Decimal, 9), new SqlParameter("@Deduct", SqlDbType.Decimal, 9), new SqlParameter("@AddDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.TaxRateID;
commandParameters[1].Value = model.TaxStartPoint;
commandParameters[2].Value = model.LowerLimit;
commandParameters[3].Value = model.UpperLimit;
commandParameters[4].Value = model.TaxRate;
commandParameters[5].Value = model.Deduct;
commandParameters[6].Value = model.AddDate;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public int Update(TaxStartPointModel model)
{
return(this.dal.Update(model));
}
public int Add(TaxStartPointModel model)
{
return(this.dal.Add(model));
}
