/// <summary>
/// 获取指定的费别ID的收费类别记录
/// </summary>
/// <param name="CHARGE_CLASS_ID"></param>
/// <returns></returns>
public override IModel GetModel(string CHARGE_CLASS_ID)
{
strSql = "select * from " + TableName + " where CHARGE_TYPE_CODE = " + CHARGE_CLASS_ID;
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MChargeClass chargeclass = new MChargeClass();
if (dt.Rows[0]["CHARGE_TYPE_CODE"].ToString() == "")
{
chargeclass.CHARGE_TYPE_CODE = null;
}
else
{
chargeclass.CHARGE_TYPE_CODE = Convert.ToInt32(dt.Rows[0]["CHARGE_TYPE_CODE"].ToString());
}
chargeclass.CHARGE_TYPE = dt.Rows[0]["CHARGE_TYPE"].ToString();
if (dt.Rows[0]["CHARGE_RATIO"].ToString() == "")
{
chargeclass.CHARGE_RATIO = null;
}
else
{
chargeclass.CHARGE_RATIO = Convert.ToDecimal(dt.Rows[0]["CHARGE_RATIO"].ToString());
}
return(chargeclass);
}
/// <summary>
/// 查询是否存在指定的收费类别记录
/// </summary>
/// <param name="ichargeclass"></param>
/// <returns></returns>
public override bool Exists(IModel ichargeclass)
{
MChargeClass chargeclass = (MChargeClass)ichargeclass;
strSql = "select * from " + TableName + " where CHARGE_TYPE_CODE=" + chargeclass.CHARGE_TYPE_CODE;
return(recordIsExist(strSql));
}
/// <summary>
/// 插入一条收费类别记录
/// </summary>
/// <param name="ichargeclass"></param>
/// <returns></returns>
public override int Add(IModel ichargeclass)
{
MChargeClass chargeclass = (MChargeClass)ichargeclass;
Hashtable ht = new Hashtable();
ht.Add("CHARGE_TYPE_CODE", chargeclass.CHARGE_TYPE_CODE);
ht.Add("CHARGE_TYPE", chargeclass.CHARGE_TYPE);
ht.Add("CHARGE_RATIO", chargeclass.CHARGE_RATIO);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 更新指定的收费类别记录
/// </summary>
/// <param name="ichargeclass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ichargeclass, string where)
{
MChargeClass chargeclass = (MChargeClass)ichargeclass;
Hashtable ht = new Hashtable();
ht.Add("CHARGE_CLASS_ID", chargeclass.CHARGE_CLASS_ID);
ht.Add("CHARGE_CLASS", chargeclass.CHARGE_CLASS);
ht.Add("CHARGE_RATIO", chargeclass.CHARGE_RATIO);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
private bool EditData()
{
Hashtable htEdit = new Hashtable();
int k = 0;
if (htRow.Count > 0)
{
foreach (DictionaryEntry myDE in htRow)
{
int r = Convert.ToInt32(myDE.Value);
MChargeClass MchgCls = new MChargeClass();
MchgCls.CHARGE_CLASS_ID = Convert.ToInt32(dgv_ChargeClass.Rows[r].Cells["CHARGE_CLASS_ID"].Value.ToString());
MchgCls.CHARGE_CLASS = dgv_ChargeClass.Rows[r].Cells["CHARGE_CLASS"].Value.ToString().Trim();
try
{
MchgCls.CHARGE_RATIO = Convert.ToInt32(dgv_ChargeClass.Rows[r].Cells["CHARGE_RATIO"].Value.ToString());
}
catch
{
}
htEdit.Add(k, MchgCls);
k += 1;
}
htRow.Clear();
i = 0;
if (bChgCls.UpdateMore(htEdit) >= 0)
{
MessageBoxEx.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else
{
MessageBoxEx.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
else
{
return(false);
}
}
private bool SaveData()
{
Hashtable ht = new Hashtable();
if (dgv_ChargeClass.Rows.Count > RowCount - 1) //说明有新增行
{
for (int i = RowCount, j = 0; i <= dgv_ChargeClass.Rows.Count && j < dgv_ChargeClass.Rows.Count; i++, j++) //从第rowcount个开始保存
{
MChargeClass MchgCls = new MChargeClass();
MchgCls.CHARGE_CLASS_ID = Convert.ToInt32(dgv_ChargeClass.Rows[i - 1].Cells["CHARGE_CLASS_ID"].Value.ToString());
MchgCls.CHARGE_CLASS = dgv_ChargeClass.Rows[i - 1].Cells["CHARGE_CLASS"].Value.ToString().Trim();
try
{
MchgCls.CHARGE_RATIO = Convert.ToInt32(dgv_ChargeClass.Rows[i - 1].Cells["CHARGE_RATIO"].Value.ToString());
}
catch
{
}
ht.Add(j, MchgCls);
}
}
if (ht.Count > 0)
{
if (bChgCls.AddMore(ht) > 0)
{
MessageBoxEx.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else
{
MessageBoxEx.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// 批量更新收费类别
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(Hashtable ht2)
{
MChargeClass chargeclass = new MChargeClass();
Hashtable ht = new Hashtable();
Hashtable htStr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
chargeclass = (MChargeClass)ht2[i];
ht.Add("CHARGE_CLASS_ID", chargeclass.CHARGE_CLASS_ID);
ht.Add("CHARGE_CLASS", chargeclass.CHARGE_CLASS);
ht.Add("CHARGE_RATIO", chargeclass.CHARGE_RATIO);
htStr.Add(i, StringConstructor.UpdateSql(TableName, ht, " where CHARGE_CLASS_ID=" + chargeclass.CHARGE_CLASS_ID));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
/// <summary>
/// 批量插入收费类别记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MChargeClass chargeclass = new MChargeClass();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
chargeclass = (MChargeClass)ht2[i];
ht.Add("CHARGE_CLASS_ID", chargeclass.CHARGE_CLASS_ID);
ht.Add("CHARGE_CLASS", chargeclass.CHARGE_CLASS);
ht.Add("CHARGE_RATIO", chargeclass.CHARGE_RATIO);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
