📄 childmgrinfo.cs
字号:
}
}
string CurrentTypeName
{
get
{
if(this.txtTypeName.Text.Trim()!=string.Empty)
return this.txtTypeName.Text.Trim();
else
return "基本资料";
}
}
#endregion
#region Method
void txtTypeName_DataBind(DataTable _dt)
{
foreach(DataRow _row in _dt.Rows)
{
this.txtTypeName.Properties.Items.Add(
new DevExpress.XtraEditors.Controls.ImageComboBoxItem(_row[1].ToString(),_row[0],-1));
}
this.txtTypeName.SelectedIndex = 0;
}
void gcClient_DataSoureSetFilter()
{
if(dtClient!=null)
{
if(this.chkAllType.Checked)
dtClient.DefaultView.RowFilter = "";
else
{
if(this.drClientType!=null)
{
dtClient.DefaultView.RowFilter = "ClientType = '"+this.drClientType["Code"].ToString()+"'";
}
else
dtClient.DefaultView.RowFilter = "1=0";
}
}
}
void gcType_DataSourceSetFilter()
{
if(dtType != null)
{
dtType.DefaultView.RowFilter = "Type = "+this.CurrentType.ToString();
this.gcolType_Code.Caption = this.txtTypeName.Text;
}
}
#endregion
#region Control EditValue Changed
private void chkAllType_CheckedChanged(object sender, System.EventArgs e)
{
this.gcClient_DataSoureSetFilter();
}
private void gvClientType_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
this.gcClient_DataSoureSetFilter();
}
private void txtTypeName_EditValueChanged(object sender, System.EventArgs e)
{
this.gcType_DataSourceSetFilter();
}
private void mainTabPages_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e)
{
DataRefresh();
}
#endregion
#region NavBarBtns ClickButton
#region Client
private void nbbClient_ClickButton(object sender, WWAM.BLL.NavBarBtns.ButtonEventArgs e)
{
switch((string)e.Button.Tag)
{
case "Append":
#region Append
DataTable _fdt = this.dtClient!=null?this.dtClient:new DataTable();
if(this.dlgClient.ShowDialog(_fdt,dtClientType) == DialogResult.OK)
{
DataRow _ndr = this.dlgClient.GetRow();
int rv = this.BaseDB.RunSPGetInt("iClientInsert",_ndr,0);
if(rv > 0)
{
_ndr["Clientid"] = rv;
WWAM.DBA.DTPro.AddRow(dtClient,_ndr);
}
else
{
string title = "客户资料添加失败";
switch(rv)
{
case -1:
this.BaseMsgBox.ShowWarning("指定的客户名称["+(string)_ndr["Code"]+"]已被占用。",title);
break;
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
#endregion
break;
case "Delete":
#region Delete
if(this.drClient!=null)
{
if(this.BaseMsgBox.ShowQuestion("您确认要删除该条客户资料数据吗？","客户资料删除")==DialogResult.OK)
{
int rv = this.BaseDB.RunSPGetInt("iClientDelete",new WWAM.DBA.SqlPara((int)this.drClient["Clientid"]),0);
if(rv>0)
{
WWAM.DBA.DTPro.RemoveRow(dtClient,drClient);
}
else
{
string title = "客户资料删除失败";
switch(rv)
{
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
}
#endregion
break;
case "Edit":
#region Edit
if(drClient != null)
{
DataTable _fdt1 = this.dtClient!=null?this.dtClient:new DataTable();
if(this.dlgClient.ShowDialog(drClient,_fdt1,dtClientType) == DialogResult.OK)
{
DataRow _ndr = this.dlgClient.GetRow();
int rv = this.BaseDB.RunSPGetInt("iClientUpdate",_ndr,0);
if(rv > 0)
{
WWAM.DBA.DRPro.CloneDataRow(_ndr,drClient);
}
else
{
string title = "客户资料修改失败";
switch(rv)
{
case -1:
this.BaseMsgBox.ShowWarning("指定的客户名称["+(string)_ndr["Code"]+"]已被占用。",title);
break;
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
}
#endregion
break;
case "Refresh":
DataRefresh();
break;
}
}
#endregion
#region Type
private void nbbPaper_ClickButton(object sender, WWAM.BLL.NavBarBtns.ButtonEventArgs e)
{
switch((string)e.Button.Tag)
{
case "Append":
#region Append
DataTable _fdt = this.dtType!=null?this.dtType:new DataTable();
if(this.dlgType.ShowDialog(this.CurrentType,this.CurrentTypeName,_fdt) == DialogResult.OK)
{
DataRow _ndr = this.dlgType.GetRow();
int rv = this.BaseDB.RunSPGetInt("bTypeInsert",_ndr,0);
if(rv > 0)
{
_ndr["Typeid"] = rv;
WWAM.DBA.DTPro.AddRow(dtType,_ndr);
}
else
{
string title = this.CurrentTypeName+"添加失败";
switch(rv)
{
case -1:
this.BaseMsgBox.ShowWarning("指定的"+this.CurrentTypeName+"名称["+(string)_ndr["Code"]+"]已被占用。",title);
break;
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
#endregion
break;
case "Delete":
#region Delete
if(this.drClient!=null)
{
if(this.BaseMsgBox.ShowQuestion("您确认要删除该条"+this.CurrentTypeName+"数据吗？",this.CurrentTypeName+"删除")==DialogResult.OK)
{
int rv = this.BaseDB.RunSPGetInt("bTypeDelete",new WWAM.DBA.SqlPara((int)this.drType["Typeid"]),0);
if(rv>0)
{
WWAM.DBA.DTPro.RemoveRow(dtType,drType);
}
else
{
string title = this.CurrentTypeName+"删除失败";
switch(rv)
{
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
}
#endregion
break;
case "Edit":
#region Edit
if(drType != null)
{
DataTable _fdt1 = this.dtType!=null?this.dtType:new DataTable();
if(this.dlgType.ShowDialog(drType,this.CurrentTypeName,_fdt1) == DialogResult.OK)
{
DataRow _ndr = this.dlgType.GetRow();
int rv = this.BaseDB.RunSPGetInt("bTypeUpdate",_ndr,0);
if(rv > 0)
{
WWAM.DBA.DRPro.CloneDataRow(_ndr,drType);
}
else
{
string title = this.CurrentTypeName+"修改失败";
switch(rv)
{
case -1:
this.BaseMsgBox.ShowWarning("指定的"+this.CurrentTypeName+"名称["+(string)_ndr["Code"]+"]已被占用。",title);
break;
case -99:
this.BaseMsgBox.ShowWarning("数据库执行错误！\r\n"+this.BaseDB.LastError,title);
break;
default:
this.BaseMsgBox.ShowWarning("未知错误！\r\n错误码："+rv.ToString(),title);
break;
}
}
}
}
#endregion
break;
case "Refresh":
DataRefresh();
break;
}
}
#endregion
#endregion }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -