/// <summary>
/// 转换Object为数组
/// </summary>
/// <param name="myConst">传入的实体</param>
void ChangeObjectToArray(Neusoft.HISFC.Models.Base.Const myConst)
{
this.stringObj[(int)enumItem.N0DepartmentCode] = myConst.ID;
this.stringObj[(int)enumItem.N1IncomeItemName] = myConst.Name;
this.stringObj[(int)enumItem.N2ItemName] = myConst.Memo;
this.stringObj[(int)enumItem.N3CurrentDepartment] = myConst.SpellCode;
this.stringObj[(int)enumItem.N4DepartmentName] = myConst.WBCode;
this.stringObj[(int)enumItem.N5ItemCode] = myConst.UserCode;
this.stringObj[(int)enumItem.N6Level] = myConst.SortID.ToString();
this.stringObj[(int)enumItem.N7ValidState] = FrameWork.Function.NConvert.ToInt32(myConst.IsValid).ToString();
this.stringObj[(int)enumItem.N8OperatorCode] = myConst.OperEnvironment.ID;
}
// 公共函数
#region 转换Reader为Object
/// <summary>
/// 转换Reader为Object
/// </summary>
/// <param name="myConst">返回的Object</param>
/// <returns>1：成功/-1：失败</returns>
int ChangeReaderToObject(ref Neusoft.HISFC.Models.Base.Const myConst)
{
myConst.ID = this.Reader[(int)enumItem.N0DepartmentCode].ToString();
myConst.Name = this.Reader[(int)enumItem.N1IncomeItemName].ToString();
myConst.Memo = this.Reader[(int)enumItem.N2ItemName].ToString();
myConst.SpellCode = this.Reader[(int)enumItem.N3CurrentDepartment].ToString();
myConst.WBCode = this.Reader[(int)enumItem.N4DepartmentName].ToString();
myConst.UserCode = this.Reader[(int)enumItem.N5ItemCode].ToString();
try
{
myConst.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[(int)enumItem.N6Level].ToString());
}
catch
{
this.Err = "转换Level失败！";
return(-1);
}
myConst.IsValid = FrameWork.Function.NConvert.ToBoolean(this.Reader[(int)enumItem.N7ValidState].ToString());
myConst.OperEnvironment.ID = this.Reader[(int)enumItem.N8OperatorCode].ToString();
return(1);
}
// 数据操作
#region 除(1：成功/0：没找到/-1：失败)(操作类型：1-删除提成项目/2-删除收费项目)
/// <summary>
/// 删除(1：成功/0：没找到/-1：失败)(操作类型：1-删除提成项目/2-删除收费项目)
/// </summary>
/// <param name="c">实体</param>
/// <param name="intOperate">操作类型：1-删除提成项目/2-删除收费项目 </param>
/// <returns>1：成功/0：没找到/-1：失败</returns>
public int Delete(Neusoft.HISFC.Models.Base.Const c, int intOperate)
{
// 返回值
int intReturn = 0;
// SQL语句
string DELETE = "Neusoft.HISFC.Management.Manager.IncomeItem.Delete";
string WHERE = "";
string SQL = "";
// 获取SQL语句
intReturn = this.Sql.GetSql(DELETE, ref DELETE);
if (intReturn == -1)
{
this.Err = "获取SQL语句失败！" + this.Err;
return(-1);
}
switch (intOperate)
{
case 1:
intReturn = this.Sql.GetSql("Neusoft.HISFC.Management.Manager.IncomeItem.Delete.Where.IncomeItem", ref WHERE);
if (intReturn == -1)
{
this.Err = "获取SQL语句失败！" + this.Err;
return(-1);
}
break;
case 2:
intReturn = this.Sql.GetSql("Neusoft.HISFC.Management.Manager.IncomeItem.Delete.Where.FeeItem", ref WHERE);
if (intReturn == -1)
{
this.Err = "获取SQL语句失败！" + this.Err;
return(-1);
}
break;
}
SQL = DELETE + " " + WHERE;
// 匹配SQL语句
try
{
switch (intOperate)
{
case 1:
SQL = String.Format(SQL, c.ID, c.Name);
break;
case 2:
SQL = String.Format(SQL, c.ID, c.Name, c.UserCode);
break;
}
}
catch (Exception e)
{
this.Err = "匹配SQL语句失败！" + e.Message;
return(-1);
}
// 执行SQL语句
return(this.ExecNoQuery(SQL));
}
