public CardManage.Model.UserInfo GetModel(int ID)
{
CardManage.Model.UserInfo model = null;
MySqlParameter[] parameters =
{
new MySqlParameter("@SelNum", MySqlDbType.Int32),
new MySqlParameter("@Where_String", MySqlDbType.VarChar)
};
parameters[0].Value = 1;
parameters[1].Value = string.Format("ID={0}", ID);
DataSet ds = DbHelperSQL.RunProcedure(string.Format("{0}_GetBywhere_Num", this._TableName), parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model = new Model.UserInfo()
{
ID = ID
};
DataRow dRow = ds.Tables[0].Rows[0];
model.UserName = Functions.FormatString(dRow["UserName"]);
model.Flag = Functions.FormatInt(dRow["Flag"]);
model.FlagDesc = Functions.FormatString(dRow["FlagDesc"]);
model.UserPwd = Functions.FormatString(dRow["UserPwd"]);
model.IfFrezen = Convert.ToBoolean(dRow["IfFrezen"]);
model.Memo = Functions.FormatString(dRow["Memo"]);
return(model);
}
else
{
return(null);
}
}
public CardViewForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
//初始化时扇区默认为1,不可编辑不可选择,扇区重置按钮默认不可见
cbCHS.Items.Clear();
cbCHS.Items.Add(RunVariable.CurrentSetting.OtherSetting.Chs);
cbCHS.SelectedIndex = 0;
#if DEBUG
cbCHS.Visible = true;
#else
cbCHS.Visible = false;
#endif
//_CurrentAction 判断是类型 是创建还是修改
this._CurrentAction = (EAction)objFlag.Keyword1;
if (objFlag.Keyword2 != null)
{
switch (this._CurrentAction)
{
case EAction.Create:
this._CurrentBuildingID = Convert.ToInt32(objFlag.Keyword2);
break;
case EAction.Edit:
this._CurrentID = Convert.ToInt32(objFlag.Keyword2);
break;
}
}
//渲染界面
gbDebg.Visible = RunVariable.IfDebug;
}
public CommLogManageForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
this.LVHeaderSetting = "序号,50|创建时间,100|数据包类型,100|数据内容,400";
}
public UserManageForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
this.HideSearchButton();
//表头
this.LVHeaderSetting = "序号,50|用户名,100|角色,180|备注,300";
}
public CardManageForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
this.SetCreateButtonText("发卡读卡");
this.SetEditButtonText("编辑卡片");
this.SetDeleteButtonText("删除卡片");
this.LVHeaderSetting = "序号,50|卡号,80|卡片类型,70|小区编码,70|楼栋编码,70|单元编码,70|房间编码,80|卡片系列号,210|卡片有效期,100|发卡时间,100|持卡者姓名,100|联系电话,100|所在房间,100|所在单元,100|所在楼栋,100|所在小区,120";
}
public TreeFormBase(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
//普通管理员没有修改功能
bool bIsSupper = objUserInfo.Flag.Equals(0);
newToolStripButton.Visible = bIsSupper;
editToolStripButton.Visible = bIsSupper;
deleteToolStripButton.Visible = bIsSupper;
}
public BuildingManageForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
HideSearchButton();
this._DataType = (this.Flag == null) ? 0 : Functions.FormatInt(this.Flag.Keyword1);
if (this._DataType < 0 || this._DataType > 4)
{
this._DataType = 0;
}
//模块表头
switch (this._DataType)
{
case 0:
this._DataTypeName = "小区";
this.LVHeaderSetting = "序号,50|小区名称,100|小区编码,80|小区序列号,220|管理员姓名,100|管理员联系电话,110";
HideTree();
break;
case 1:
this._DataTypeName = "楼栋";
this.LVHeaderSetting = "序号,50|楼栋名称,100|楼栋编码,80|所在小区,100|管理员姓名,100|管理员联系电话,110";
break;
case 2:
this._DataTypeName = "单元";
this.LVHeaderSetting = "序号,50|单元名称,100|单元编码,80|所在楼栋,100|所在小区,120|管理员姓名,100|管理员联系电话,110";
break;
case 3:
this._DataTypeName = "房间";
this.LVHeaderSetting = "序号,50|房间名称,100|房间编码,80|所在单元,100|所在楼栋,100|所在小区,120|管理员姓名,100|管理员联系电话,110";
break;
}
}
public int Add(CardManage.Model.UserInfo model, out string strErrorInfo)
{
strErrorInfo = "";
MySqlParameter[] parameters =
{
new MySqlParameter("@ErrorInfo", MySqlDbType.VarChar, 500),
new MySqlParameter("@NewID", MySqlDbType.Int32),
new MySqlParameter("@Tag", MySqlDbType.Int32), //类型
new MySqlParameter("@iID", MySqlDbType.Int32),
new MySqlParameter("@iUserName", MySqlDbType.VarChar),
new MySqlParameter("@iUserPwd", MySqlDbType.VarChar),
new MySqlParameter("@iFlag", MySqlDbType.Int32),
new MySqlParameter("@iIfFrezen", MySqlDbType.Int32),
new MySqlParameter("@iMemo", MySqlDbType.VarChar)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
parameters[2].Value = 0;//新增
parameters[3].Value = 0;
parameters[4].Value = model.UserName;
parameters[5].Value = model.UserPwd;
parameters[6].Value = model.Flag;
parameters[7].Value = model.IfFrezen;
parameters[8].Value = model.Memo;
try
{
DbHelperSQL.RunProcedure(string.Format("{0}_ADD_UPDATE", this._TableName), parameters, out int rowsAffected);
strErrorInfo = Functions.FormatString(parameters[0].Value);
int iNewID = Functions.FormatInt(parameters[1].Value);
return(iNewID);
}
catch (MySqlException ex)
{
strErrorInfo = ex.Message;
return(0);
}
}
public SetFormBase(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
if (this.Text == "数据库备份")
{
this.label100.Text = "备份时请选择您要保存的位置与备份文件名";
this.btnOK.Text = "备份";
}
else if (this.Text == "数据库还原")
{
this.label100.Text = "还原时请选择您要还原的数据库备份文件";
this.btnOK.Text = "还原";
}
else
{
this.label100.Text = "";
this.label100.Visible = false;
}
// this.btnOK
// this.btnCancel
}
public FormBase(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
{
this.CurrentUserInfo = (objUserInfo == null) ? null : (UserInfo)objUserInfo.Clone();
this.WindowSize = objWindowSize;
this.Flag = objFlag;
InitializeComponent();
this.Text = strTitle;
this.StartPosition = FormStartPosition.CenterParent;
if (bIsModal)
{
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Width = (objWindowSize == null) ? this._DefaultWidth : objWindowSize.Width;
this.Height = (objWindowSize == null) ? this._DefaultHeight : objWindowSize.Height;
this.MaximumSize = this.Size;
this.MinimumSize = this.Size;
}
else
{
this.WindowState = FormWindowState.Maximized;
}
}
public SelectBuildingForm(string strTitle, bool bIsModal, CardManage.Model.UserInfo objUserInfo, CardManage.Model.WindowSize objWindowSize = null, CardManage.Model.Flag objFlag = null)
: base(strTitle, bIsModal, objUserInfo, objWindowSize, objFlag)
{
InitializeComponent();
this.Text = strTitle;
}
