public int Update(YHFramework.SysModel.ExecutePlanModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ExecutePlan set ");
strSql.Append("CodeType=@CodeType,MaxCount=@MaxCount,EachCount=@EachCount,BatchCodeBegin=@BatchCodeBegin,EffectiveDateBegin=@EffectiveDateBegin,GeneratedCount=@GeneratedCount,CurrentBatchCode=@CurrentBatchCode,Status=@Status,CustomerEmail=@CustomerEmail ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@CodeType", DbTool.FixSqlParameter(model.CodeType))
, new SqlParameter("@MaxCount", DbTool.FixSqlParameter(model.MaxCount))
, new SqlParameter("@EachCount", DbTool.FixSqlParameter(model.EachCount))
, new SqlParameter("@BatchCodeBegin", DbTool.FixSqlParameter(model.BatchCodeBegin))
, new SqlParameter("@EffectiveDateBegin", DbTool.FixSqlParameter(model.EffectiveDateBegin))
, new SqlParameter("@GeneratedCount", DbTool.FixSqlParameter(model.GeneratedCount))
, new SqlParameter("@CurrentBatchCode", DbTool.FixSqlParameter(model.CurrentBatchCode))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public dynamic AddGet(T item)
{
using (var db = DbTool.GetDb())
{
return(db.Insert(item));
}
}
public int Update(UpInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UpInfo set ");
strSql.Append("Title=@Title,FileName=@FileName,ApployTime=@ApployTime,BathCode=@BathCode,Secret=@Secret,CustomerEmail=@CustomerEmail,Type=@Type,Url=@Url,Status=@Status,CreatedTime=@CreatedTime,UpdateTime=@UpdateTime,DownTime=@DownTime,CompleteTime=@CompleteTime,Remarks=@Remarks ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@ApployTime", DbTool.FixSqlParameter(model.ApployTime))
, new SqlParameter("@BathCode", DbTool.FixSqlParameter(model.BathCode))
, new SqlParameter("@Secret", DbTool.FixSqlParameter(model.Secret))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Type", DbTool.FixSqlParameter(model.Type))
, new SqlParameter("@Url", DbTool.FixSqlParameter(model.Url))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CreatedTime", DbTool.FixSqlParameter(model.CreatedTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@DownTime", DbTool.FixSqlParameter(model.DownTime))
, new SqlParameter("@CompleteTime", DbTool.FixSqlParameter(model.CompleteTime))
, new SqlParameter("@Remarks", DbTool.FixSqlParameter(model.Remarks))
, new SqlParameter("@ID", model.ID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public virtual T FindBy(K key)
{
using (var db = DbTool.GetDb())
{
return(db.Get <T>(key));
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (Adapter != null && listBox1.SelectedItem != null)
{
selectTable = listBox1.SelectedItem.ToString();
tableCols = Adapter.GetColumns(selectTable);
this.listView1.BeginUpdate();
List <Dictionary <String, Object> > columns = new List <Dictionary <string, object> >();
foreach (var col in tableCols)
{
Dictionary <String, Object> column = new Dictionary <String, Object>();
column.Add("columnDbName", col.ColumnName);
column.Add("columnDbType", col.ColumnType);
column.Add("columnComment", col.ColumnComment);
column.Add("columnName", DbTool.tramsCamel(col.ColumnName));
column.Add("columnType", DbTool.getJavaTypeByDbType(col.ColumnType));
columns.Add(column);
ListViewItem lvi = new ListViewItem();
lvi.Text = col.ColumnName;
lvi.SubItems.Add(col.ColumnType);
lvi.SubItems.Add(col.IsNullable);
this.listView1.Items.Add(lvi);
}
addArgs("columns", columns);
this.listView1.EndUpdate();
generateArgs();
renderTemplate();
}
}
public virtual IEnumerable <T> FindAll()
{
using (var db = DbTool.GetDb())
{
return(db.GetList <T>());
}
}
public virtual bool Remove(T item)
{
using (var db = DbTool.GetDb())
{
return(db.Delete(item));
}
}
public void Run()
{
do
{
Console.CursorVisible = true;
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine($"\r\n------- {user.FirstName} {user.LastName} profile -------"); Console.ResetColor();
DbTool.NewMessageNotification(user);
Console.WriteLine(user + "\r\n");
Console.WriteLine("write 'help' for instructions");
string uCommand = MainApplication.CommandLine();
Console.WriteLine();
if (user.Licence == "Super Administrator")
{
AdministratorRunEnviroment(uCommand);
}
else if (user.Licence != "Super Administrator")
{
OtherUsersRunEnviroment(uCommand);
}
else
{
Console.WriteLine("something went wrong");
}
Console.Clear();
} while (true);
}
private Curorder CreateCurorder()
{
string id = DateTime.Now.ToString("yyyyMMddHHmmssfff");
Curorder order = new Curorder();
order.AllDiscount = "0";
order.Amount = OrderedDishAmount;
order.CurorderId = "ZD" + id;
order.Discount = 0;
order.DiscountRate = 1.00m;
order.DishAmount = OrderedDishAmount;
order.FreeCharge = 0;
order.HmeOrderId = "CRM" + App.ShopId + id;
order.HmeUserId = 0;
order.Operatorname = App.OperatorName;
order.OrderDate = DateTime.Now;
order.Paytype = PayType;
order.PeopleNum = 0;
order.Posname = "快餐厅";
order.PrepayAmount = 0;
order.Roomfee = 0;
order.Shift = DbTool.GetShift();
order.Shouldpay = OrderedDishAmount;
order.Srvfee = 0.00m;
order.SrvRate = 0.00m;
order.TableName = App.TableName;
order.HmeTableId = App.HmeTableId;
order.Waiter = App.OperatorName;
order.Yetpay = OrderedDishAmount;
return(order);
}
protected ActionLogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new ActionLogModel();
if (DbTool.HasFields("ActionLogId", fields))
{
model.ActionLogId = DbTool.ConvertObject <System.Int32>(dr["ActionLogId"]);
}
if (DbTool.HasFields("ActionName", fields))
{
model.ActionName = DbTool.ConvertObject <System.String>(dr["ActionName"]);
}
if (DbTool.HasFields("UserName", fields))
{
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
}
if (DbTool.HasFields("ActionResult", fields))
{
model.ActionResult = DbTool.ConvertObject <System.String>(dr["ActionResult"]);
}
if (DbTool.HasFields("KeyData", fields))
{
model.KeyData = DbTool.ConvertObject <System.String>(dr["KeyData"]);
}
if (DbTool.HasFields("Notes", fields))
{
model.Notes = DbTool.ConvertObject <System.String>(dr["Notes"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
return(model);
}
public int Update(YHFramework.SysModel.BoxNumberModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BoxNumber set ");
strSql.Append("BoxNumber=@BoxNumber,ShortBoxNumber=@ShortBoxNumber,IndexCode=@IndexCode,BatchNumber=@BatchNumber,ContentStatusId=@ContentStatusId,IsBind=@IsBind,BindTime=@BindTime,UpdateOn=@UpdateOn,CreateOn=@CreateOn,ApployInfoId=@ApployInfoId ");
strSql.Append(" where BoxNumberId=@BoxNumberId ");
SqlParameter[] parameters =
{
new SqlParameter("@BoxNumber", DbTool.FixSqlParameter(model.BoxNumber))
, new SqlParameter("@ShortBoxNumber", DbTool.FixSqlParameter(model.ShortBoxNumber))
, new SqlParameter("@IndexCode", DbTool.FixSqlParameter(model.IndexCode))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@IsBind", DbTool.FixSqlParameter(model.IsBind))
, new SqlParameter("@BindTime", DbTool.FixSqlParameter(model.BindTime))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
, new SqlParameter("@BoxNumberId", model.BoxNumberId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
private void generateArgs()
{
if (String.IsNullOrEmpty(selectTable))
{
return;
}
if (!String.IsNullOrEmpty(tb_ex_prefix.Text))
{
String[] prefix = tb_ex_prefix.Text.Split(',');
String modelName = selectTable;
//去表名前缀
foreach (var p in prefix)
{
modelName = modelName.Replace(p, "");
}
//驼峰命名生曾实体类名
modelName = DbTool.tramsCamel(modelName);
String modelNameVariable = modelName;
modelName = modelName.Substring(0, 1).ToUpper() + modelName.Substring(1);
String bizName = modelName.ToLower();
this.tb_bizName.Text = bizName;
this.tb_modelName.Text = modelName;
addArgs("modelName", modelName);
addArgs("modelNameVariable", modelNameVariable);
addArgs("bizName", bizName);
addArgs("namespace", String.IsNullOrEmpty(tb_url.Text) ? bizName : tb_url.Text);
}
}
public int Update(YHFramework.SysModel.CodeDataModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CodeData set ");
strSql.Append("CodeData=@CodeData,ShortCodeData=@ShortCodeData,CodeIndex=@CodeIndex,BatchNumber=@BatchNumber,BoxNumberId=@BoxNumberId,ContentStatusId=@ContentStatusId,UpdateOn=@UpdateOn,Createon=@Createon,ApployInfoId=@ApployInfoId ");
strSql.Append(" where CodeDataId=@CodeDataId ");
SqlParameter[] parameters =
{
new SqlParameter("@CodeData", DbTool.FixSqlParameter(model.CodeData))
, new SqlParameter("@ShortCodeData", DbTool.FixSqlParameter(model.ShortCodeData))
, new SqlParameter("@CodeIndex", DbTool.FixSqlParameter(model.CodeIndex))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@BoxNumberId", DbTool.FixSqlParameter(model.BoxNumberId))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@Createon", DbTool.FixSqlParameter(model.Createon))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
, new SqlParameter("@CodeDataId", model.CodeDataId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(YHFramework.SysModel.BoxNumberModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BoxNumber]");
strSql.Append("(BoxNumber,ShortBoxNumber,IndexCode,BatchNumber,ContentStatusId,IsBind,BindTime,UpdateOn,CreateOn,ApployInfoId)");
strSql.Append(" values (@BoxNumber,@ShortBoxNumber,@IndexCode,@BatchNumber,@ContentStatusId,@IsBind,@BindTime,@UpdateOn,@CreateOn,@ApployInfoId)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@BoxNumber", DbTool.FixSqlParameter(model.BoxNumber))
, new SqlParameter("@ShortBoxNumber", DbTool.FixSqlParameter(model.ShortBoxNumber))
, new SqlParameter("@IndexCode", DbTool.FixSqlParameter(model.IndexCode))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@IsBind", DbTool.FixSqlParameter(model.IsBind))
, new SqlParameter("@BindTime", DbTool.FixSqlParameter(model.BindTime))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(UpInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [UpInfo]");
strSql.Append("(Title,FileName,ApployTime,BathCode,Secret,CustomerEmail,Type,Url,Status,CreatedTime,UpdateTime,DownTime,CompleteTime,Remarks)");
strSql.Append(" values (@Title,@FileName,@ApployTime,@BathCode,@Secret,@CustomerEmail,@Type,@Url,@Status,@CreatedTime,@UpdateTime,@DownTime,@CompleteTime,@Remarks)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@ApployTime", DbTool.FixSqlParameter(model.ApployTime))
, new SqlParameter("@BathCode", DbTool.FixSqlParameter(model.BathCode))
, new SqlParameter("@Secret", DbTool.FixSqlParameter(model.Secret))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Type", DbTool.FixSqlParameter(model.Type))
, new SqlParameter("@Url", DbTool.FixSqlParameter(model.Url))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CreatedTime", DbTool.FixSqlParameter(model.CreatedTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@DownTime", DbTool.FixSqlParameter(model.DownTime))
, new SqlParameter("@CompleteTime", DbTool.FixSqlParameter(model.CompleteTime))
, new SqlParameter("@Remarks", DbTool.FixSqlParameter(model.Remarks))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public virtual bool Update(T item)
{
using (var db = DbTool.GetDb())
{
return(db.Update(item));
}
}
public void test()
{
Log4NetConfig.Configure();
try
{
var mpaccounts = StaticObjects.wechatdh.ExecuteTable("select ID,Name from MpAccount where IsDelete=0 and isnull(AutoSyncUser,0)=1").AsEnumerable().Select(c => new
{
ID = DbTool.ToString(c["ID"]),
Name = DbTool.ToString(c["Name"]),
});
foreach (var mp in mpaccounts)
{
try
{
LogWriter.Info(string.Format("同步公众号{0}[{1}]的分组开始", mp.Name, mp.ID));
RefreshGroup(mp.ID);
LogWriter.Info(string.Format("同步公众号{0}[{1}]的分组结束", mp.Name, mp.ID));
LogWriter.Info(string.Format("同步公众号{0}[{1}]的用户开始", mp.Name, mp.ID));
ReFreshFans(mp.ID);
LogWriter.Info(string.Format("同步公众号{0}[{1}]的用户结束", mp.Name, mp.ID));
}
catch (Exception ex)
{
LogWriter.Error(ex, string.Format("同步公众号{0}[{1}]的分组和用户出现错误", mp.Name, mp.ID));
}
}
}
catch (Exception ex)
{
LogWriter.Error(ex, "同步微信分组和用户出现错误");
throw ex;
}
}
public virtual bool RemoveAll()
{
using (var db = DbTool.GetDb())
{
return(db.DelteAll <T>());
}
}
public int CheckCount(string sqlwhere)
{
StringBuilder sql = new StringBuilder();
sql.Append("select count(1) from IpAccessControlLog where 1=1 ");
sql.Append(sqlwhere);
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql.ToString()), 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetCodeRowCountByAppId(int appId)
{
string sql = "select COUNT(*) from dbo.CodeData where ContentStatusId=1 and ApployInfoId= " + appId;
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCount(string sqlwhere)
{
string sql = "select count(*) from ApployInfo where 1=1 " + sqlwhere;
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCount()
{
string sql = "select count(*) from UpInfo ";
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
public virtual bool Add(T item)
{
using (var db = DbTool.GetDb())
{
db.Insert(item);
}
return(true);
}
protected void BindDataReader(Model.Security.IpAccessControlSettingModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.IPAccessEnable = DbTool.ConvertObject <System.Boolean>(dr["IPAccessEnable"]);
model.IPAccessMaxCount = DbTool.ConvertObject <System.Int32>(dr["IPAccessMaxCount"]);
model.IPAccessControlTime = DbTool.ConvertObject <System.Int32>(dr["IPAccessControlTime"]);
model.IPAccessControlLockTime = DbTool.ConvertObject <System.Int32>(dr["IPAccessControlLockTime"]);
}
protected void BindDataReader(ActionLogModel model, SqlDataReader dr)
{
model.ActionLogId = DbTool.ConvertObject <System.Int32>(dr["ActionLogId"]);
model.ActionName = DbTool.ConvertObject <System.String>(dr["ActionName"]);
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
model.ActionResult = DbTool.ConvertObject <System.String>(dr["ActionResult"]);
model.KeyData = DbTool.ConvertObject <System.String>(dr["KeyData"]);
model.Notes = DbTool.ConvertObject <System.String>(dr["Notes"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
protected void BindDataReader(Model.Security.IpAccessControlModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
model.AccessCount = DbTool.ConvertObject <System.Int32>(dr["AccessCount"]);
model.Islocked = DbTool.ConvertObject <System.Boolean>(dr["Islocked"]);
model.FistDateTime = DbTool.ConvertObject <System.DateTime>(dr["FistDateTime"]);
model.UpdateDate = DbTool.ConvertObject <System.DateTime>(dr["UpdateDate"]);
}
protected void BindDataReader(YHFramework.SysModel.ApployCheckLogModel model, SqlDataReader dr)
{
model.CheckLogId = DbTool.ConvertObject <System.Int32>(dr["CheckLogId"]);
model.ApployId = DbTool.ConvertObject <System.Int32>(dr["ApployId"]);
model.TypeCode = DbTool.ConvertObject <System.String>(dr["TypeCode"]);
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
model.Number = DbTool.ConvertObject <System.Int64>(dr["Number"]);
model.Message = DbTool.ConvertObject <System.String>(dr["Message"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
}
protected void BindDataReader(Model.Security.IpAccessControlLogModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.LockedDate = DbTool.ConvertObject <System.DateTime>(dr["LockedDate"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.LockValue = DbTool.ConvertObject <System.String>(dr["LockValue"]);
model.LockReason = DbTool.ConvertObject <System.String>(dr["LockReason"]);
model.SourceURL = DbTool.ConvertObject <System.String>(dr["SourceURL"]);
}
protected void BindDataReader(YHFramework.SysModel.CodeDataModel model, SqlDataReader dr)
{
model.CodeDataId = DbTool.ConvertObject <System.Int32>(dr["CodeDataId"]);
model.CodeData = DbTool.ConvertObject <System.String>(dr["CodeData"]);
model.ShortCodeData = DbTool.ConvertObject <System.String>(dr["ShortCodeData"]);
model.CodeIndex = DbTool.ConvertObject <System.String>(dr["CodeIndex"]);
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
model.ContentStatusId = DbTool.ConvertObject <System.Int32>(dr["ContentStatusId"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
model.Createon = DbTool.ConvertObject <System.DateTime>(dr["Createon"]);
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
protected void BindDataReader(YHFramework.SysModel.ExecutePlanModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.CodeType = DbTool.ConvertObject <System.Int32>(dr["CodeType"]);
model.MaxCount = DbTool.ConvertObject <System.Int32>(dr["MaxCount"]);
model.EachCount = DbTool.ConvertObject <System.Int32>(dr["EachCount"]);
model.BatchCodeBegin = DbTool.ConvertObject <System.Int32>(dr["BatchCodeBegin"]);
model.EffectiveDateBegin = DbTool.ConvertObject <System.DateTime>(dr["EffectiveDateBegin"]);
model.GeneratedCount = DbTool.ConvertObject <System.Int32>(dr["GeneratedCount"]);
model.CurrentBatchCode = DbTool.ConvertObject <System.Int32>(dr["CurrentBatchCode"]);
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
}
public EventSourceTreeArgs(EventSourceType type = EventSourceType.Open, DbTool.DbForms.SourceTree.TreeNodeType treeNodeType= SourceTree.TreeNodeType.TABLE,object obj = null)
{
_eventSourceType = type;
_sourceObject = obj;
_treeNodeType = treeNodeType;
}