public List<BussinessOR> selectBankData(string orgbhWhere)
{
if (string.IsNullOrEmpty(orgbhWhere))
return null;
string sql = @"select bu.* from t_Bussiness bu
inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere;
DataTable dt = null;
try
{
dt = dbMsSql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
List<BussinessOR> listBussi = new List<BussinessOR>();
foreach (DataRow dr in dt.Rows)
{
BussinessOR obj = new BussinessOR(dr);
listBussi.Add(obj);
}
return listBussi;
}
/// <summary>
/// 获取插入数据
/// </summary>
public string GetInsertSql(BussinessOR bussiness)
{
string sql = string.Format(@"insert into t_Bussiness (Id, Name, EnglishName, TypeName, WaitTime1,
PriorTime1, WaitTime2, PriorTime2, WaitTime3, PriorTime3,
TicketMethod, MondayFlag, MondayTime, TuesdayFlag, TuesdayTime,
WednesdayFlag, WednesdayTime, ThurdayFlag, ThurdayTime, FridayFlag,
FridayTime, SaturdayFlag, SaturdayTime, SundayFlag, SundayTime,
Description, OrgBH,prefix)
values ('@Id', '@Name', '@EnglishName', '@TypeName', @WaitTime1,
@PriorTime1, @WaitTime2,@PriorTime2, @WaitTime3, @PriorTime3,
@TicketMethod, @MondayFlag, '@MondayTime', @TuesdayFlag, '@TuesdayTime',
@WednesdayFlag, '@WednesdayTime', @ThurdayFlag, '@ThurdayTime', @FridayFlag,
'@FridayTime', @SaturdayFlag, '@SaturdayTime', @SundayFlag, '@SundayTime',
'@Description', '@OrgBH','@prefix')");
sql = sql.Replace("@Id", bussiness.Id);
sql = sql.Replace("@Name", bussiness.Name);
sql = sql.Replace("@EnglishName", bussiness.Englishname);
sql = sql.Replace("@TypeName", bussiness.Typename);
sql = sql.Replace("@WaitTime1", bussiness.Waittime1.ToString());
sql = sql.Replace("@PriorTime1", bussiness.Priortime1.ToString());
sql = sql.Replace("@WaitTime2", bussiness.Waittime2.ToString());
sql = sql.Replace("@PriorTime2", bussiness.Priortime2.ToString());
sql = sql.Replace("@WaitTime3", bussiness.Waittime3.ToString());
sql = sql.Replace("@PriorTime3", bussiness.Priortime3.ToString());
sql = sql.Replace("@TicketMethod", bussiness.Ticketmethod.ToString());
sql = sql.Replace("@MondayFlag", boolGetFlag(bussiness.Mondayflag));
sql = sql.Replace("@MondayTime", bussiness.Mondaytime);
sql = sql.Replace("@TuesdayFlag", boolGetFlag(bussiness.Tuesdayflag));
sql = sql.Replace("@TuesdayTime", bussiness.Tuesdaytime);
sql = sql.Replace("@WednesdayFlag", boolGetFlag(bussiness.Wednesdayflag));
sql = sql.Replace("@WednesdayTime", bussiness.Wednesdaytime);
sql = sql.Replace("@ThurdayFlag", boolGetFlag(bussiness.Thurdayflag));
sql = sql.Replace("@ThurdayTime", bussiness.Thurdaytime);
sql = sql.Replace("@FridayFlag", boolGetFlag(bussiness.Fridayflag));
sql = sql.Replace("@FridayTime", bussiness.Fridaytime);
sql = sql.Replace("@SaturdayFlag", boolGetFlag(bussiness.Saturdayflag));
sql = sql.Replace("@SaturdayTime", bussiness.Saturdaytime);
sql = sql.Replace("@SundayFlag", boolGetFlag(bussiness.Sundayflag));
sql = sql.Replace("@SundayTime", bussiness.Sundaytime);
sql = sql.Replace("@Description", bussiness.Description);
sql = sql.Replace("@OrgBH", bussiness.Orgbh);
sql = sql.Replace("@prefix", bussiness.Prefix);
return sql;
}
public BussinessOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_Bussiness where Id='{0}'", m_id);
DataTable dt = null;
try
{
dt = dbMsSql.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
BussinessOR m_Buss = new BussinessOR(dr);
return m_Buss;
}
/// <summary>
/// 获取业务优先时间
/// </summary>
/// <param name="TimeLen"></param>
/// <param name="obj"></param>
/// <returns></returns>
private int GetPriorTime(int TimeLen, BussinessOR obj)
{
if (TimeLen > obj.Waittime3)
{
return obj.Priortime3;
}
else if (TimeLen > obj.Waittime2)
{
return obj.Priortime2;
}
else if (TimeLen > obj.Waittime1)
{
return obj.Priortime1;
}
return 0;
}
public List<BussinessOR> selectAllBussiness()
{
string sql = "select * from t_Bussiness";
DataTable dt = null;
try
{
dt = dbMySql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
{
return null;
}
List<BussinessOR> listBuss = new List<BussinessOR>();
foreach (DataRow dr in dt.Rows)
{
BussinessOR obj = new BussinessOR(dr);
listBuss.Add(obj);
}
return listBuss;
}
public void Init(BussinessOR obj)
{
//
this.Id = obj.Id;
// 业务名称
this.Name = obj.Name;
// 英文的业务名称，用于界面显示（可选）
this.Englishname = obj.Englishname;
// 业务种类，相当于业务名称的缩写，比如业务名称为“存取款和缴费”，则业务种类为“M1”
this.Typename = obj.Typename;
// 等候时间1
this.Waittime1 = obj.Waittime1;
// 优先时间1 。“等候时间1”和“优先时间1”指客户等待时间1大于XX秒时，排队优先时间1等于YY秒
this.Priortime1 = obj.Priortime1;
// 等候时间2
this.Waittime2 = obj.Waittime2;
// 优先时间2。同理，等候时间2需大于等候时间1
this.Priortime2 = obj.Priortime2;
// 等候时间3
this.Waittime3 = obj.Waittime3;
// 优先时间3。同理，等候时间3需大于等候时间2
this.Priortime3 = obj.Priortime3;
// 取号方式。1是刷卡取号----此队列必须刷卡取号。2是直接取号----直接取号无需刷卡。3是刷卡直接取号----可以直接取号也可刷卡取号
this.Ticketmethod = obj.Ticketmethod;
// 周一是否办理的标记，1表示办理，0表示不能办理
this.Mondayflag = obj.Mondayflag;
// 周一工作时间，不能超过3个时间段，各时间段以分号隔开。如08301200;13001400;15001800;表示从8:30到12:00，然后13:00到14:00,然后15:00到18:00.只有1个时间段时为08301200;;;
this.Mondaytime = obj.Mondaytime;
// 周二办理标记
this.Tuesdayflag = obj.Tuesdayflag;
// 周二工作时间
this.Tuesdaytime = obj.Tuesdaytime;
// 周三办理标记
this.Wednesdayflag = obj.Wednesdayflag;
// 周三工作时间
this.Wednesdaytime = obj.Wednesdaytime;
// 周l四办理标记
this.Thurdayflag = obj.Thurdayflag;
// 周四工作时间
this.Thurdaytime = obj.Thurdaytime;
// 周五办理标记
this.Fridayflag = obj.Fridayflag;
// 周五工作时间
this.Fridaytime = obj.Fridaytime;
// 周六办理标记
this.Saturdayflag = obj.Saturdayflag;
// 周六办理标记
this.Saturdaytime = obj.Saturdaytime;
// 周日办理标记
this.Sundayflag = obj.Sundayflag;
// 周日工作时间
this.Sundaytime = obj.Sundaytime;
// 描述
this.Description = obj.Description;
// 机构编号
this.Orgbh = obj.Orgbh;
//前缀
this.Prefix = obj.Prefix;
}
