public int Add(PEIS.Model.OnCustFee model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OnCustFee(");
stringBuilder.Append("ID_Customer,FeeItemName,ID_Register,RegisterName,RegistDate,OriginalPrice,Discount,FactPrice,ID_Discounter,DiscounterName,Is_FeeCharged,ID_FeeCharger,FeeCharger,FeeChargeTime,Is_FeeRefund,ID_FeeRefunder,FeeRefunder,Is_Examined,ID_ExamDoctor,ExamDoctorName,ExamDate,Is_Discard,ID_FeeType,ID_Fee)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_Customer,@FeeItemName,@ID_Register,@RegisterName,@RegistDate,@OriginalPrice,@Discount,@FactPrice,@ID_Discounter,@DiscounterName,@Is_FeeCharged,@ID_FeeCharger,@FeeCharger,@FeeChargeTime,@Is_FeeRefund,@ID_FeeRefunder,@FeeRefunder,@Is_Examined,@ID_ExamDoctor,@ExamDoctorName,@ExamDate,@Is_Discard,@ID_FeeType,@ID_Fee)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
new SqlParameter("@FeeItemName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Register", SqlDbType.Int, 4),
new SqlParameter("@RegisterName", SqlDbType.VarChar, 30),
new SqlParameter("@RegistDate", SqlDbType.DateTime),
new SqlParameter("@OriginalPrice", SqlDbType.Float, 8),
new SqlParameter("@Discount", SqlDbType.Int, 4),
new SqlParameter("@FactPrice", SqlDbType.Float, 8),
new SqlParameter("@ID_Discounter", SqlDbType.Int, 4),
new SqlParameter("@DiscounterName", SqlDbType.VarChar, 30),
new SqlParameter("@Is_FeeCharged", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeCharger", SqlDbType.Int, 4),
new SqlParameter("@FeeCharger", SqlDbType.VarChar, 30),
new SqlParameter("@FeeChargeTime", SqlDbType.DateTime),
new SqlParameter("@Is_FeeRefund", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeRefunder", SqlDbType.Int, 4),
new SqlParameter("@FeeRefunder", SqlDbType.VarChar, 30),
new SqlParameter("@Is_Examined", SqlDbType.Bit, 1),
new SqlParameter("@ID_ExamDoctor", SqlDbType.Int, 4),
new SqlParameter("@ExamDoctorName", SqlDbType.VarChar, 30),
new SqlParameter("@ExamDate", SqlDbType.DateTime),
new SqlParameter("@Is_Discard", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeType", SqlDbType.Int, 4),
new SqlParameter("@ID_Fee", SqlDbType.Int, 4)
};
array[0].Value = model.ID_Customer;
array[1].Value = model.FeeItemName;
array[2].Value = model.ID_Register;
array[3].Value = model.RegisterName;
array[4].Value = model.RegistDate;
array[5].Value = model.OriginalPrice;
array[6].Value = model.Discount;
array[7].Value = model.FactPrice;
array[8].Value = model.ID_Discounter;
array[9].Value = model.DiscounterName;
array[10].Value = model.Is_FeeCharged;
array[11].Value = model.ID_FeeCharger;
array[12].Value = model.FeeCharger;
array[13].Value = model.FeeChargeTime;
array[14].Value = model.Is_FeeRefund;
array[15].Value = model.ID_FeeRefunder;
array[16].Value = model.FeeRefunder;
array[17].Value = model.Is_Examined;
array[18].Value = model.ID_ExamDoctor;
array[19].Value = model.ExamDoctorName;
array[20].Value = model.ExamDate;
array[21].Value = model.Is_Discard;
array[22].Value = model.ID_FeeType;
array[23].Value = model.ID_Fee;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public PEIS.Model.OnCustFee GetModel(int ID_CustFee)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_CustFee,ID_Customer,FeeItemName,ID_Register,RegisterName,RegistDate,OriginalPrice,Discount,FactPrice,ID_Discounter,DiscounterName,Is_FeeCharged,ID_FeeCharger,FeeCharger,FeeChargeTime,Is_FeeRefund,ID_FeeRefunder,FeeRefunder,Is_Examined,ID_ExamDoctor,ExamDoctorName,ExamDate,Is_Discard,ID_FeeType,ID_Fee from OnCustFee ");
stringBuilder.Append(" where ID_CustFee=@ID_CustFee");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_CustFee", SqlDbType.Int, 4)
};
array[0].Value = ID_CustFee;
PEIS.Model.OnCustFee onCustFee = new PEIS.Model.OnCustFee();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.OnCustFee result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_CustFee"].ToString() != "")
{
onCustFee.ID_CustFee = int.Parse(dataSet.Tables[0].Rows[0]["ID_CustFee"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_Customer"].ToString() != "")
{
onCustFee.ID_Customer = new long?(long.Parse(dataSet.Tables[0].Rows[0]["ID_Customer"].ToString()));
}
onCustFee.FeeItemName = dataSet.Tables[0].Rows[0]["FeeItemName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Register"].ToString() != "")
{
onCustFee.ID_Register = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Register"].ToString()));
}
onCustFee.RegisterName = dataSet.Tables[0].Rows[0]["RegisterName"].ToString();
if (dataSet.Tables[0].Rows[0]["RegistDate"].ToString() != "")
{
onCustFee.RegistDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["RegistDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["OriginalPrice"].ToString() != "")
{
onCustFee.OriginalPrice = decimal.Parse(dataSet.Tables[0].Rows[0]["OriginalPrice"].ToString());
}
if (dataSet.Tables[0].Rows[0]["Discount"].ToString() != "")
{
onCustFee.Discount = int.Parse(dataSet.Tables[0].Rows[0]["Discount"].ToString());
}
if (dataSet.Tables[0].Rows[0]["FactPrice"].ToString() != "")
{
onCustFee.FactPrice = decimal.Parse(dataSet.Tables[0].Rows[0]["FactPrice"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_Discounter"].ToString() != "")
{
onCustFee.ID_Discounter = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Discounter"].ToString()));
}
onCustFee.DiscounterName = dataSet.Tables[0].Rows[0]["DiscounterName"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_FeeCharged"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_FeeCharged"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_FeeCharged"].ToString().ToLower() == "true")
{
onCustFee.Is_FeeCharged = true;
}
else
{
onCustFee.Is_FeeCharged = false;
}
}
if (dataSet.Tables[0].Rows[0]["ID_FeeCharger"].ToString() != "")
{
onCustFee.ID_FeeCharger = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FeeCharger"].ToString()));
}
onCustFee.FeeCharger = dataSet.Tables[0].Rows[0]["FeeCharger"].ToString();
if (dataSet.Tables[0].Rows[0]["FeeChargeTime"].ToString() != "")
{
onCustFee.FeeChargeTime = DateTime.Parse(dataSet.Tables[0].Rows[0]["FeeChargeTime"].ToString());
}
if (dataSet.Tables[0].Rows[0]["Is_FeeRefund"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_FeeRefund"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_FeeRefund"].ToString().ToLower() == "true")
{
onCustFee.Is_FeeRefund = new bool?(true);
}
else
{
onCustFee.Is_FeeRefund = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_FeeRefunder"].ToString() != "")
{
onCustFee.ID_FeeRefunder = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FeeRefunder"].ToString()));
}
onCustFee.FeeRefunder = dataSet.Tables[0].Rows[0]["FeeRefunder"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_Examined"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Examined"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Examined"].ToString().ToLower() == "true")
{
onCustFee.Is_Examined = new bool?(true);
}
else
{
onCustFee.Is_Examined = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_ExamDoctor"].ToString() != "")
{
onCustFee.ID_ExamDoctor = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ExamDoctor"].ToString()));
}
onCustFee.ExamDoctorName = dataSet.Tables[0].Rows[0]["ExamDoctorName"].ToString();
if (dataSet.Tables[0].Rows[0]["ExamDate"].ToString() != "")
{
onCustFee.ExamDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ExamDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_Discard"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Discard"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Discard"].ToString().ToLower() == "true")
{
onCustFee.Is_Discard = new bool?(true);
}
else
{
onCustFee.Is_Discard = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_FeeType"].ToString() != "")
{
onCustFee.ID_FeeType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FeeType"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_Fee"].ToString() != "")
{
onCustFee.ID_Fee = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Fee"].ToString()));
}
result = onCustFee;
}
else
{
result = null;
}
return(result);
}
public bool Update(PEIS.Model.OnCustFee model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnCustFee set ");
stringBuilder.Append("ID_Customer=@ID_Customer,");
stringBuilder.Append("FeeItemName=@FeeItemName,");
stringBuilder.Append("ID_Register=@ID_Register,");
stringBuilder.Append("RegisterName=@RegisterName,");
stringBuilder.Append("RegistDate=@RegistDate,");
stringBuilder.Append("OriginalPrice=@OriginalPrice,");
stringBuilder.Append("Discount=@Discount,");
stringBuilder.Append("FactPrice=@FactPrice,");
stringBuilder.Append("ID_Discounter=@ID_Discounter,");
stringBuilder.Append("DiscounterName=@DiscounterName,");
stringBuilder.Append("Is_FeeCharged=@Is_FeeCharged,");
stringBuilder.Append("ID_FeeCharger=@ID_FeeCharger,");
stringBuilder.Append("FeeCharger=@FeeCharger,");
stringBuilder.Append("FeeChargeTime=@FeeChargeTime,");
stringBuilder.Append("Is_FeeRefund=@Is_FeeRefund,");
stringBuilder.Append("ID_FeeRefunder=@ID_FeeRefunder,");
stringBuilder.Append("FeeRefunder=@FeeRefunder,");
stringBuilder.Append("Is_Examined=@Is_Examined,");
stringBuilder.Append("ID_ExamDoctor=@ID_ExamDoctor,");
stringBuilder.Append("ExamDoctorName=@ExamDoctorName,");
stringBuilder.Append("ExamDate=@ExamDate,");
stringBuilder.Append("Is_Discard=@Is_Discard,");
stringBuilder.Append("ID_FeeType=@ID_FeeType,");
stringBuilder.Append("ID_Fee=@ID_Fee");
stringBuilder.Append(" where ID_CustFee=@ID_CustFee");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
new SqlParameter("@FeeItemName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Register", SqlDbType.Int, 4),
new SqlParameter("@RegisterName", SqlDbType.VarChar, 30),
new SqlParameter("@RegistDate", SqlDbType.DateTime),
new SqlParameter("@OriginalPrice", SqlDbType.Float, 8),
new SqlParameter("@Discount", SqlDbType.Int, 4),
new SqlParameter("@FactPrice", SqlDbType.Float, 8),
new SqlParameter("@ID_Discounter", SqlDbType.Int, 4),
new SqlParameter("@DiscounterName", SqlDbType.VarChar, 30),
new SqlParameter("@Is_FeeCharged", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeCharger", SqlDbType.Int, 4),
new SqlParameter("@FeeCharger", SqlDbType.VarChar, 30),
new SqlParameter("@FeeChargeTime", SqlDbType.DateTime),
new SqlParameter("@Is_FeeRefund", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeRefunder", SqlDbType.Int, 4),
new SqlParameter("@FeeRefunder", SqlDbType.VarChar, 30),
new SqlParameter("@Is_Examined", SqlDbType.Bit, 1),
new SqlParameter("@ID_ExamDoctor", SqlDbType.Int, 4),
new SqlParameter("@ExamDoctorName", SqlDbType.VarChar, 30),
new SqlParameter("@ExamDate", SqlDbType.DateTime),
new SqlParameter("@Is_Discard", SqlDbType.Bit, 1),
new SqlParameter("@ID_FeeType", SqlDbType.Int, 4),
new SqlParameter("@ID_Fee", SqlDbType.Int, 4),
new SqlParameter("@ID_CustFee", SqlDbType.Int, 4)
};
array[0].Value = model.ID_Customer;
array[1].Value = model.FeeItemName;
array[2].Value = model.ID_Register;
array[3].Value = model.RegisterName;
array[4].Value = model.RegistDate;
array[5].Value = model.OriginalPrice;
array[6].Value = model.Discount;
array[7].Value = model.FactPrice;
array[8].Value = model.ID_Discounter;
array[9].Value = model.DiscounterName;
array[10].Value = model.Is_FeeCharged;
array[11].Value = model.ID_FeeCharger;
array[12].Value = model.FeeCharger;
array[13].Value = model.FeeChargeTime;
array[14].Value = model.Is_FeeRefund;
array[15].Value = model.ID_FeeRefunder;
array[16].Value = model.FeeRefunder;
array[17].Value = model.Is_Examined;
array[18].Value = model.ID_ExamDoctor;
array[19].Value = model.ExamDoctorName;
array[20].Value = model.ExamDate;
array[21].Value = model.Is_Discard;
array[22].Value = model.ID_FeeType;
array[23].Value = model.ID_Fee;
array[24].Value = model.ID_CustFee;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public List <PEIS.Model.OnCustFee> DataTableToList(DataTable dt)
{
List <PEIS.Model.OnCustFee> list = new List <PEIS.Model.OnCustFee>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.OnCustFee onCustFee = new PEIS.Model.OnCustFee();
if (dt.Rows[i]["ID_CustFee"].ToString() != "")
{
onCustFee.ID_CustFee = int.Parse(dt.Rows[i]["ID_CustFee"].ToString());
}
if (dt.Rows[i]["ID_Customer"].ToString() != "")
{
onCustFee.ID_Customer = new long?(long.Parse(dt.Rows[i]["ID_Customer"].ToString()));
}
onCustFee.FeeItemName = dt.Rows[i]["FeeItemName"].ToString();
if (dt.Rows[i]["ID_Register"].ToString() != "")
{
onCustFee.ID_Register = new int?(int.Parse(dt.Rows[i]["ID_Register"].ToString()));
}
onCustFee.RegisterName = dt.Rows[i]["RegisterName"].ToString();
if (dt.Rows[i]["RegistDate"].ToString() != "")
{
onCustFee.RegistDate = new DateTime?(DateTime.Parse(dt.Rows[i]["RegistDate"].ToString()));
}
if (dt.Rows[i]["OriginalPrice"].ToString() != "")
{
onCustFee.OriginalPrice = decimal.Parse(dt.Rows[i]["OriginalPrice"].ToString());
}
if (dt.Rows[i]["Discount"].ToString() != "")
{
onCustFee.Discount = int.Parse(dt.Rows[i]["Discount"].ToString());
}
if (dt.Rows[i]["FactPrice"].ToString() != "")
{
onCustFee.FactPrice = decimal.Parse(dt.Rows[i]["FactPrice"].ToString());
}
if (dt.Rows[i]["ID_Discounter"].ToString() != "")
{
onCustFee.ID_Discounter = new int?(int.Parse(dt.Rows[i]["ID_Discounter"].ToString()));
}
onCustFee.DiscounterName = dt.Rows[i]["DiscounterName"].ToString();
if (dt.Rows[i]["Is_FeeCharged"].ToString() != "")
{
if (dt.Rows[i]["Is_FeeCharged"].ToString() == "1" || dt.Rows[i]["Is_FeeCharged"].ToString().ToLower() == "true")
{
onCustFee.Is_FeeCharged = true;
}
else
{
onCustFee.Is_FeeCharged = false;
}
}
if (dt.Rows[i]["ID_FeeCharger"].ToString() != "")
{
onCustFee.ID_FeeCharger = new int?(int.Parse(dt.Rows[i]["ID_FeeCharger"].ToString()));
}
onCustFee.FeeCharger = dt.Rows[i]["FeeCharger"].ToString();
if (dt.Rows[i]["FeeChargeTime"].ToString() != "")
{
onCustFee.FeeChargeTime = DateTime.Parse(dt.Rows[i]["FeeChargeTime"].ToString());
}
if (dt.Rows[i]["Is_FeeRefund"].ToString() != "")
{
if (dt.Rows[i]["Is_FeeRefund"].ToString() == "1" || dt.Rows[i]["Is_FeeRefund"].ToString().ToLower() == "true")
{
onCustFee.Is_FeeRefund = new bool?(true);
}
else
{
onCustFee.Is_FeeRefund = new bool?(false);
}
}
if (dt.Rows[i]["ID_FeeRefunder"].ToString() != "")
{
onCustFee.ID_FeeRefunder = new int?(int.Parse(dt.Rows[i]["ID_FeeRefunder"].ToString()));
}
onCustFee.FeeRefunder = dt.Rows[i]["FeeRefunder"].ToString();
if (dt.Rows[i]["Is_Examined"].ToString() != "")
{
if (dt.Rows[i]["Is_Examined"].ToString() == "1" || dt.Rows[i]["Is_Examined"].ToString().ToLower() == "true")
{
onCustFee.Is_Examined = new bool?(true);
}
else
{
onCustFee.Is_Examined = new bool?(false);
}
}
if (dt.Rows[i]["ID_ExamDoctor"].ToString() != "")
{
onCustFee.ID_ExamDoctor = new int?(int.Parse(dt.Rows[i]["ID_ExamDoctor"].ToString()));
}
onCustFee.ExamDoctorName = dt.Rows[i]["ExamDoctorName"].ToString();
if (dt.Rows[i]["ExamDate"].ToString() != "")
{
onCustFee.ExamDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ExamDate"].ToString()));
}
if (dt.Rows[i]["Is_Discard"].ToString() != "")
{
if (dt.Rows[i]["Is_Discard"].ToString() == "1" || dt.Rows[i]["Is_Discard"].ToString().ToLower() == "true")
{
onCustFee.Is_Discard = new bool?(true);
}
else
{
onCustFee.Is_Discard = new bool?(false);
}
}
if (dt.Rows[i]["ID_FeeType"].ToString() != "")
{
onCustFee.ID_FeeType = new int?(int.Parse(dt.Rows[i]["ID_FeeType"].ToString()));
}
if (dt.Rows[i]["ID_Fee"].ToString() != "")
{
onCustFee.ID_Fee = new int?(int.Parse(dt.Rows[i]["ID_Fee"].ToString()));
}
list.Add(onCustFee);
}
}
return(list);
}
public bool Update(PEIS.Model.OnCustFee model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.OnCustFee model)
{
return(this.dal.Add(model));
}