public Flow GetFlow(int id)
{
string sql = "select * from Flow where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
int templateId = Convert.ToInt32(dt.Rows[0]["TemplateID"]);
FlowTemplate template = FlowTemplateLogic.GetInstance().GetFlowTemplate(templateId);
List <TaskStage> stages = new List <TaskStage>();
string stagesIds = dt.Rows[0]["Stages"].ToString();
string[] stageIdList = stagesIds.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (string stageId in stageIdList)
{
TaskStage stage = TaskStageLogic.GetInstance().GetTaskStage(Convert.ToInt32(stageId));
if (stage != null)
{
stages.Add(stage);
}
}
Flow element = new Flow(Convert.ToInt32(dt.Rows[0]["ID"]), dt.Rows[0]["Name"].ToString(), template, Convert.ToInt32(dt.Rows[0]["CurrentIndex"]), dt.Rows[0]["Remark"].ToString(), stages);
return(element);
}
return(null);
}
public Permission GetPermission(int id)
{
string sql = "select * from TF_Permission where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Permission perm = new Permission();
perm.ID = id;
perm.Name = dt.Rows[0]["Name"].ToString();
perm.IsExcept = Convert.ToBoolean(dt.Rows[0]["IsExcept"]);
perm.TheModule = ModuleLogic.GetInstance().GetModule(Convert.ToInt32(dt.Rows[0]["TheModule"]));
perm.TheAction = ActionLogic.GetInstance().GetAction(Convert.ToInt32(dt.Rows[0]["TheAction"]));
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
perm.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
perm.Remark = "";
}
return(perm);
}
return(null);
}
public Dairy GetDairy(int id)
{
string sql = "select * from TF_Dairy where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Dairy element = new Dairy();
element.ID = id;
element.Pos机会籍 = Convert.ToDecimal(dt.Rows[0]["Pos机会籍"]);
element.Pos机私教 = Convert.ToDecimal(dt.Rows[0]["Pos机私教"]);
element.现金会籍 = Convert.ToDecimal(dt.Rows[0]["现金会籍"]);
element.现金私教 = Convert.ToDecimal(dt.Rows[0]["现金私教"]);
element.微信会籍 = Convert.ToDecimal(dt.Rows[0]["微信会籍"]);
element.微信私教 = Convert.ToDecimal(dt.Rows[0]["微信私教"]);
element.现金存水 = Convert.ToDecimal(dt.Rows[0]["现金存水"]);
element.微信存水 = Convert.ToDecimal(dt.Rows[0]["微信存水"]);
element.水吧余 = Convert.ToDecimal(dt.Rows[0]["水吧余"]);
element.总金额 = Convert.ToDecimal(dt.Rows[0]["总金额"]);
element.备注 = dt.Rows[0]["备注"].ToString();
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["经手人"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
return(element);
}
return(null);
}
/// <summary>
/// 查询单个数据的方法
/// </summary>
public DataTable GetOneTable(int id)
{
string sqlStr = "select ID as ID,ConfigName as ConfigName,ConfigValue as ConfigValue,ConfigType as ConfigType,Remark as Remark,Extension as Extension,Flag as Flag from TF_Config where ID=@ID";
SqlParameter[] parms = { new SqlParameter("@ID", id) };
DataTable dtResult = sqlHelper.Query(sqlStr, false, parms);
return(dtResult);
}
public TaskInfo GetTaskInfo(int id)
{
string sql = "select * from TaskInfo where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FlowLogic ftl = FlowLogic.GetInstance();
TaskInfo element = new TaskInfo(Convert.ToInt32(dt.Rows[0]["ID"]), Convert.ToInt32(dt.Rows[0]["EntityId"]), ftl.GetFlow(Convert.ToInt32(dt.Rows[0]["FlowID"])), dt.Rows[0]["Sponsor"].ToString(), dt.Rows[0]["Remark"].ToString());
return(element);
}
return(null);
}
public FieldMap <T, K> GetFieldMap(int id)
{
string sql = "select * from TF_FieldMap where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FieldMap <T, K> element = new FieldMap <T, K>();
element.ID = id;
element.Name = dt.Rows[0]["Name"].ToString();
element.Map = (byte[])dt.Rows[0]["Map"];
return(element);
}
return(null);
}
internal void GetRemoteConfig()
{
if (configs == null)
{
configs = new List <ConfigEntity>();
}
SQLDBHelper sqlHelper = new SQLDBHelper();
DataTable dt = sqlHelper.Query("select * from TF_Config");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ConfigEntity config = new ConfigEntity();
config.id = Convert.ToInt32(dt.Rows[i]["ID"]);
config.configname = dt.Rows[i]["ConfigName"].ToString();
config.configvalue = dt.Rows[i]["ConfigValue"].ToString();
config.configtype = Convert.ToInt32(dt.Rows[i]["ConfigType"]);
config.remark = dt.Rows[i]["Remark"].ToString();
config.extension = Convert.ToInt32(dt.Rows[i]["Extension"]);
config.flag = Convert.ToInt32(dt.Rows[i]["Flag"]);
configs.Add(config);
}
}
}
public FormType GetFormType(int id)
{
string sql = "select * from TF_FormType where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FormType element = new FormType();
element.ID = id;
element.TypeName = dt.Rows[0]["TypeName"].ToString();
element.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
element.Remark = dt.Rows[0]["Remark"].ToString();
return(element);
}
return(null);
}
public CardType GetCardType(int id)
{
string sql = "select * from TF_CardType where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
CardType element = new CardType();
element.ID = id;
element.卡种 = dt.Rows[0]["卡种"].ToString();
element.是否电子芯片 = Convert.ToBoolean(dt.Rows[0]["是否电子芯片"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public StaffCondition GetStaffCondition(int id)
{
string sql = "select * from TF_StaffCondition where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
StaffCondition element = new StaffCondition();
element.ID = id;
element.状态 = dt.Rows[0]["状态"].ToString();
element.是否在职 = Convert.ToBoolean(dt.Rows[0]["是否在职"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public FollowupType GetFollowupType(int id)
{
string sql = "select * from TF_FollowupType where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FollowupType element = new FollowupType();
element.ID = id;
element.方式 = dt.Rows[0]["方式"].ToString();
element.Flag = Convert.ToBoolean(dt.Rows[0]["Flag"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public FormItem GetFormItem(int id)
{
string sql = "select * from TF_FormItem where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FormItem element = new FormItem();
element.ID = id;
element.ItemName = dt.Rows[0]["ItemName"].ToString();
element.ItemValue = dt.Rows[0]["ItemValue"].ToString();
element.ItemType = dt.Rows[0]["ItemType"].ToString();
element.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
return(element);
}
return(null);
}
public FormObject GetFormObject(int id)
{
string sql = "select * from TF_FormObject where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FormObject element = new FormObject();
element.ID = id;
element.FormName = dt.Rows[0]["FormName"].ToString();
element.FormType = FormTypeLogic.GetInstance().GetFormType(Convert.ToInt32(dt.Rows[0]["FormType"]));
element.FormItems = FormItemLogic.GetInstance().GetFormItemsByIds(dt.Rows[0]["FormItems"].ToString());
element.Owner = UserLogic.GetInstance().GetUser(Convert.ToInt32(dt.Rows[0]["Owner"]));
element.Remark = dt.Rows[0]["Remark"].ToString();
return(element);
}
return(null);
}
public Property GetProperty(int id)
{
string sql = "select * from TF_Property where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Property property = new Property();
property.ID = id;
property.称 = dt.Rows[0]["名称"].ToString();
property.单位 = dt.Rows[0]["单位"].ToString();
property.用途 = dt.Rows[0]["用途"].ToString();
property.价格 = Convert.ToDecimal(dt.Rows[0]["价格"]);
property.备注 = dt.Rows[0]["备注"].ToString();
return(property);
}
return(null);
}
public Attachment GetAttachment(int id)
{
string sql = "select * from TF_Attachment where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Attachment attach = new Attachment();
attach.ID = id;
attach.AttachmentFilename = dt.Rows[0]["AttachmentFilename"].ToString();
attach.Size = Convert.ToInt64(dt.Rows[0]["Size"]);
attach.Uploader = UserLogic.GetInstance().GetUser(Convert.ToInt32(dt.Rows[0]["Uploader"]));
attach.UploadTime = Convert.ToDateTime(dt.Rows[0]["UploadTime"]);
attach.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
return(attach);
}
return(null);
}
public Inventory GetInventory(int id)
{
string sql = "select * from TF_Inventory where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Inventory element = new Inventory();
element.ID = id;
element.PID = Convert.ToInt32(dt.Rows[0]["PID"]);
element.IsProduct = Convert.ToBoolean(dt.Rows[0]["IsProduct"]);
element.IsIncome = Convert.ToBoolean(dt.Rows[0]["IsIncome"]);
element.数量 = Convert.ToDecimal(dt.Rows[0]["数量"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Renew GetRenew(int id)
{
string sql = "select * from TF_Renew where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Renew element = new Renew();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.卡种 = CardTypeLogic.GetInstance().GetCardType(Convert.ToInt32(dt.Rows[0]["CardType"]));
element.卡号 = dt.Rows[0]["卡号"].ToString();
element.续卡时间 = Convert.ToDateTime(dt.Rows[0]["续卡时间"]);
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["经手人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Followup GetFollowup(int id)
{
string sql = "select * from TF_Followup where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Followup element = new Followup();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.回访方式 = FollowupTypeLogic.GetInstance().GetFollowupType(Convert.ToInt32(dt.Rows[0]["跟进方式"]));
element.跟进结果 = FollowupResultLogic.GetInstance().GetFollowupResult(Convert.ToInt32(dt.Rows[0]["跟进结果"]));
element.跟进时间 = Convert.ToDateTime(dt.Rows[0]["跟进时间"]);
element.跟进人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["跟进人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Workplan GetWorkplan(int id)
{
string sql = "select * from TF_Workplan where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Workplan element = new Workplan();
element.ID = id;
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
element.带人数 = Convert.ToInt32(dt.Rows[0]["带人数"]);
element.号码数 = Convert.ToInt32(dt.Rows[0]["号码数"]);
element.成单数 = Convert.ToInt32(dt.Rows[0]["成单数"]);
element.回访数 = Convert.ToInt32(dt.Rows[0]["回访数"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public FinanceDetail GetFinanceDetail(int id)
{
string sql = "select * from TF_FinanceDetail where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FinanceDetail element = new FinanceDetail();
element.ID = id;
element.项目 = dt.Rows[0]["项目"].ToString();
element.金额 = Convert.ToDecimal(dt.Rows[0]["金额"]);
element.是否进账 = Convert.ToBoolean(dt.Rows[0]["是否进账"]);
element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["责任人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
element.提交时间 = Convert.ToDateTime(dt.Rows[0]["提交时间"]);
element.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
return(element);
}
return(null);
}
public PersonalTrain GetPersonalTrain(int id)
{
string sql = "select * from TF_PersonalTrain where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
PersonalTrain element = new PersonalTrain();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.私教项目 = dt.Rows[0]["私教项目"].ToString();
element.次数 = Convert.ToInt32(dt.Rows[0]["次数"]);
element.开始日期 = Convert.ToDateTime(dt.Rows[0]["开始日期"]);
element.结束日期 = Convert.ToDateTime(dt.Rows[0]["结束日期"]);
element.教练 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["教练"]));
element.备注 = dt.Rows[0]["备注"].ToString();
element.SaleTime = Convert.ToDateTime(dt.Rows[0]["SaleTime"]);
return(element);
}
return(null);
}
public Finance GetFinance(int id)
{
string sql = "select * from TF_Finance where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Finance element = new Finance();
element.ID = id;
element.项目 = dt.Rows[0]["项目"].ToString();
element.金额 = Convert.ToDecimal(dt.Rows[0]["金额"]);
element.是否进账 = Convert.ToBoolean(dt.Rows[0]["是否进账"]);
element.余款 = Convert.ToDecimal(dt.Rows[0]["余款"]);
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
element.经手人 = dt.Rows[0]["经手人"].ToString();
element.接收人 = dt.Rows[0]["接收人"].ToString();
element.Detail = dt.Rows[0]["Detail"].ToString();
return(element);
}
return(null);
}
public UserGroup GetUserGroup(int id)
{
string sql = "select * from TF_UserGroup where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
UserGroup ug = new UserGroup();
ug.ID = id;
ug.Name = dt.Rows[0]["Name"].ToString();
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
ug.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
ug.Remark = "";
}
return(ug);
}
return(null);
}
public Action GetAction(int id)
{
string sql = "select * from TF_Action where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Action action = new Action();
action.ID = id;
action.Name = dt.Rows[0]["Name"].ToString();
if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value)
{
action.FormName = dt.Rows[0]["FormName"].ToString();
}
else
{
action.FormName = "";
}
if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value)
{
action.ControlName = dt.Rows[0]["ControlName"].ToString();
}
else
{
action.ControlName = "";
}
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
action.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
action.Remark = "";
}
return(action);
}
return(null);
}
public Module GetModule(int id)
{
string sql = "select * from TF_Module where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Module module = new Module();
module.ID = id;
module.Name = dt.Rows[0]["Name"].ToString();
if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value)
{
module.FormName = dt.Rows[0]["FormName"].ToString();
}
else
{
module.FormName = "";
}
if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value)
{
module.ControlName = dt.Rows[0]["ControlName"].ToString();
}
else
{
module.ControlName = "";
}
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
module.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
module.Remark = "";
}
return(module);
}
return(null);
}
public Product GetProduct(int id)
{
string sql = "select * from TF_Product where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Product element = new Product();
element.ID = id;
element.品名 = dt.Rows[0]["品名"].ToString();
element.种类 = ProductTypeLogic.GetInstance().GetProductType(Convert.ToInt32(dt.Rows[0]["种类"]));
element.单位 = dt.Rows[0]["单位"].ToString();
element.进价 = Convert.ToDecimal(dt.Rows[0]["进价"]);
element.售价 = Convert.ToDecimal(dt.Rows[0]["售价"]);
element.厂家 = dt.Rows[0]["厂家"].ToString();
element.姓名 = dt.Rows[0]["姓名"].ToString();
element.电话 = dt.Rows[0]["电话"].ToString();
element.地址 = dt.Rows[0]["地址"].ToString();
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Role GetRole(int id)
{
string sql = "select * from TF_Role where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Role role = new Role();
role.ID = id;
role.Name = dt.Rows[0]["Name"].ToString();
role.Flag = Convert.ToBoolean(dt.Rows[0]["Flag"]);
role.Permissions = Common.GetPermissions(dt.Rows[0]["Permissions"].ToString());
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
role.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
role.Remark = "";
}
return(role);
}
return(null);
}
public FlowTemplate GetFlowTemplate(int id)
{
string sql = "select * from FlowTemplate where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tsl = TaskStageTemplateLogic.GetInstance();
List <TaskStageTemplate> stages = new List <TaskStageTemplate>();
string stageIds = dt.Rows[0]["Stages"].ToString();
List <string> idList = Flow.GetSatges(stageIds);
foreach (string idStr in idList)
{
TaskStageTemplate stage = tsl.GetTaskStageTemplate(Convert.ToInt32(idStr));
if (stage != null)
{
stages.Add(stage);
}
}
FlowTemplate element = new FlowTemplate(Convert.ToInt32(dt.Rows[0]["ID"]), dt.Rows[0]["Name"].ToString(), stages);
return(element);
}
return(null);
}
public Worklog GetWorklog(int id)
{
string sql = "select * from TF_Worklog where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Worklog element = new Worklog();
element.ID = id;
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
element.客户 = dt.Rows[0]["客户"].ToString();
element.电话 = dt.Rows[0]["电话"].ToString();
element.是否自访 = Convert.ToBoolean(dt.Rows[0]["是否自访"]);
element.是否老会员 = Convert.ToBoolean(dt.Rows[0]["是否老会员"]);
element.是否电话拜访 = Convert.ToBoolean(dt.Rows[0]["是否电话拜访"]);
element.性别 = (性别)Enum.ToObject(typeof(性别), Convert.ToInt32(dt.Rows[0]["性别"]));
element.意向 = dt.Rows[0]["意向"].ToString();
element.住址 = dt.Rows[0]["住址"].ToString();
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public User GetUser(int id)
{
string sql = "select * from TF_User where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
User user = new User();
user.ID = id;
user.Username = dt.Rows[0]["Username"].ToString();
user.Departments = Common.GetDepartments(dt.Rows[0]["Depart"].ToString());
user.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
if (dt.Rows[0]["Password"] != null && dt.Rows[0]["Password"] != DBNull.Value)
{
user.Password = dt.Rows[0]["Password"].ToString();
}
else
{
user.Password = "";
}
if (dt.Rows[0]["Roles"] != null && dt.Rows[0]["Roles"] != DBNull.Value)
{
user.Roles = Common.GetRoles(dt.Rows[0]["Roles"].ToString());
}
if (dt.Rows[0]["Usergroup"] != null && dt.Rows[0]["Usergroup"] != DBNull.Value)
{
user.Usergroups = Common.GetUserGroups(dt.Rows[0]["Usergroup"].ToString());
}
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
user.Remark = dt.Rows[0]["Remark"].ToString();
}
return(user);
}
return(null);
}