本文整理汇总了C#中HS.Business.SCommBB.Dispose方法的典型用法代码示例。如果您正苦于以下问题：C# SCommBB.Dispose方法的具体用法？C# SCommBB.Dispose怎么用？C# SCommBB.Dispose使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类HS.Business.SCommBB的用法示例。
在下文中一共展示了SCommBB.Dispose方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BindGrid
/// <summary>
/// 绑定Grid
/// </summary>
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
DataSet ds = new DataSet();
try
{
//ds = commBB.Query("exec Proc_GetSapOutStockSaleBillList '" + this.tbAbsEntry.Text.Trim().Replace("'", "''")
// + "','" + this.tbSaleBillNo.Text.Trim().Replace("'", "''") + "','"
// + this.tbMaterial.Text.Trim().Replace("'", "''") + "'");
string AbsEntry = "";
string SaleBillNo = this.tbSaleBillNo.Text.Trim();
string material = this.tbMaterial.Text.Trim();
string invoiceNo = this.tbinvoiceNo.Text;
string custNo = this.tbcustNo.Text;
//ds = commBB.Query("exec [dbo].[Proc_ newGetSapOutStockSaleBillList] '" + this.tbAbsEntry.Text.Trim().Replace("'", "''")
// + "','" + this.tbSaleBillNo.Text.Trim().Replace("'", "''") + "','"
// + "','" + this.tbMaterial.Text.Trim().Replace("'", "''") + "','"
// + this.tbinvoiceNo.Text.Trim().Replace("'", "''") + "'");
ds = commBB.Query("exec [dbo].[Proc_GetSapOutStockSaleBillListNew] '" + AbsEntry + "','" + SaleBillNo + "','" + material + "','" + invoiceNo + "','"+custNo+"'");
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
commBB.Dispose();
}
}示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["functionNo"] != null && Request.Params["functionNo"].Trim() != "")
{
this.FunctionNo = Request.Params["functionNo"];
}
}
if (this.SET_SQL.Value != "")
{
this.SET_SQL.Value = this.SET_SQL.Value.Substring(0, this.SET_SQL.Value.Length - 1);
SCommBB commBB = new SCommBB();
try
{
string[] updateSqls = this.SET_SQL.Value.Split(';');
foreach (string updateSql in updateSqls)
{
commBB.ExecuteSql(updateSql);
}
}
finally
{
commBB.Dispose();
}
this.SET_SQL.Value = "";
}
this.ShowPullInfo(this.FunctionNo);
}示例3: BindGrid
/// <summary>
/// 绑定库存汇总列表
/// </summary>
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
try
{
DataSet ds = new DataSet();
ds = commBB.Query("exec proc_StockTotalReportNew '" + this.ddlWare.SelectedValue + "','"
+ this.ddlWareLocater.SelectedValue + "','" + this.tbFinanceBillNo.Text.Trim().Replace("'", "''").Trim() + "','"
+ this.tbMaterial.Text.Trim().Replace("'", "''").Trim() + "','" + this.ddlIsOutStocking.SelectedValue + "','" + this.ddlCheckResult.SelectedValue + "'");
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
commBB.Dispose();
}
}示例4: BindGrid
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
DataSet ds = new DataSet();
try
{
string arriveBillNo = "", FinanceBillNo = "", Material = "", custno = "";
arriveBillNo = this.tbarrivebillNo.Text.ToString();
FinanceBillNo = "";
Material = this.tbMaterial.Text.Trim();
ds = commBB.Query("exec [Proc_GetSapOtherInStockArriveBillListNew] '" + arriveBillNo + "','" + FinanceBillNo + "','" + Material + "','" + custno + "'");
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
commBB.Dispose();
}
}示例5: BindGrid
/// <summary>
/// 绑定Grid
/// </summary>
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
DataSet ds = new DataSet();
try
{
string arriveBillNo = "", FinanceBillNo = "", Material = "", custno = "";
arriveBillNo = this.tbArriveBillNo.Text.Trim();
FinanceBillNo = this.tbFinanceBillNo.Text.Trim();
Material = this.tbMaterial.Text.Trim();
custno = this.tbCustNO.Text.Trim();
if (!Checkbox.Checked)
{
ds = commBB.Query("exec Proc_GetSapInStockArriveBillListNew '" + arriveBillNo + "','" + FinanceBillNo + "','" + Material + "','" + custno + "'");//查询的是没有同步的
}
else
{
//[Proc_GetSapInStockArriveBillListNewAreadyInstocked] 这个是获取已经入库的
ds = commBB.Query("exec Proc_GetSapInStockArriveBillListNewAreadyInstocked '" + arriveBillNo + "','" + FinanceBillNo + "','" + Material + "','" + custno + "'");//查询的是没有同步的
}
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
commBB.Dispose();
}
}示例6: btnInsertImg_Click
/// <summary>
/// ���ͼƬ
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnInsertImg_Click(object sender, EventArgs e)
{
//�ж��ϴ��ؼ��Ƿ�Ϊ��
if (this.FileInsertImg.PostedFile.FileName == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"������ѡ��һ��ͼƬ�ļ�!\");", true);
return;
}
this.btnInsertImg.Enabled = false;
//�ж��ļ���ʽ��0�����ơ�1ͼƬ��
FileInfo file = new FileInfo(this.FileInsertImg.PostedFile.FileName);
string extension = file.Extension;
SCommBB commBB = new SCommBB();
try
{
//�鿴�ļ���ʽ�Ƿ������ϵͳ���ͼƬ�ļ���ʽ����
if (commBB.Query("select 1 from SImageFileType where fileExtension='" + extension + "'").Tables[0].Rows.Count == 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"���θ����ϴ�Ҫ��ΪͼƬ��ʽ�ļ���������ѡ��!\");", true);
this.btnInsertImg.Enabled = true;
return;
}
}
finally
{
commBB.Dispose();
}
//��ȡ�ļ�����
string fileNm = DateTime.Now.ToString("yyyyMMddHHmmss");
Random ro = new Random();
fileNm += ro.Next(1000, 9999).ToString() + extension;
//�ϴ��ļ���ָ��Ŀ¼
this.FileInsertImg.PostedFile.SaveAs(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\Images\\UpImg\\" + fileNm);
//�ж�ͼƬ�ߴ磬�����ʾΪ400/300
System.Drawing.Image image = System.Drawing.Image.FromFile(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\Images\\UpImg\\" + fileNm);
if (image.Width > 400)
{
this.content.Value += "<img alt=\"\" src=\"../../../Images/UpImg/" + fileNm + "\" width=\"400\" height=\"" + 400 * image.Height / image.Width + "\" />";
}
else if (image.Height > 300)
{
this.content.Value += "<img alt=\"\" src=\"../../../Images/UpImg/" + fileNm + "\" width=\"" + 300 * image.Width / image.Height + "\" height=\"300\" />";
}
else
{
this.content.Value += "<img alt=\"\" src=\"../../../Images/UpImg/" + fileNm + "\" />";
}
this.btnInsertImg.Enabled = true;
}示例7: BindGrid
private void BindGrid()
{
string billNo = this.tbBillNo.Text.ToString();
string material = this.tbMaterial.Text.ToString();
string saleBillNo = this.tbsaleBillNo.Text.ToString();
SCommBB commBB = new SCommBB();
try
{
this.gridSaleBill.DataSource = commBB.Query("exec [dbo].[pro_GetoutSaleDetailShow] '" + material + "','" + billNo + "','" + saleBillNo + "'").Tables[0];
this.gridSaleBill.DataBind();
}
catch { }
finally
{
commBB.Dispose();
}
}示例8: btnData_Click
/// <summary>
/// 获取SAP数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnData_Click(object sender, EventArgs e)
{
SCommBB commBB = new SCommBB();
try
{
//获取SAP到货单、销售订单
commBB.ExecuteSql("exec up_SAP_GetNewData");
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('同步SAP到货\\拣货数据成功！');", true);
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
commBB.Dispose();
}
}示例9: btnChangeBox_Click
/// <summary>
/// 修改关联的托盘号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnChangeBox_Click(object sender, EventArgs e)
{
if (txtBoxNo.Text.ToString() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"箱号不能为空!\");", true);
return;
}
if (txtPalletNewNo.Text.ToString()=="")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"托盘号不能为空!\");", true);
return;
}
if (txtBoxNo.Text.ToString().ToUpper().Substring(0, 1) != "X" || txtPalletNewNo.Text.ToString().ToUpper().Substring(0,1)!="T")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"箱号或是托盘号不正确!\");", true);
return;
}
SCommBB comm = new SCommBB();
try
{
comm.ExecuteSql("Update BarrangeBillBox set PalletNo = '" + txtPalletNewNo.Text.Trim().ToUpper() + "' where boxNo = '" + txtBoxNo.Text.Trim().ToUpper() + "'");
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新托盘号成功 箱号 " + txtBoxNo.Text.Trim().ToUpper() + " 更新后的托盘是" + txtPalletNewNo.Text.Trim().ToUpper() + "!\");", true);
}
catch (Exception ee)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新托盘号失败 " + ee.Message + "!\");", true);
}
finally
{
txtBoxNo.Text = "";
txtPalletNewNo.Text = "";
comm.Dispose();
}
}示例10: BindGrid
/// <summary>
/// 绑定集货区库位使用情况列表
/// </summary>
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
try
{
DataSet ds = new DataSet();
ds = commBB.Query("exec Proc_GetJHQWareInfo '" + this.tbCustNo.Text.Trim().Replace("'", "''") + "'");
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
commBB.Dispose();
}
}示例11: BindGrid
protected void BindGrid()
{
SCommBB commBB = new SCommBB();
try
{
string strStartDt = "";
string strEndDt = "";
//开始入库日期
if (!string.IsNullOrEmpty(this.tbStartDt.Text.Trim()))
{
strStartDt = this.tbStartDt.Text.Trim().ToUpper();
}
//截止入库日期
if (!string.IsNullOrEmpty(this.tbEndDt.Text.Trim()))
{
strEndDt = this.tbEndDt.Text.Trim().ToUpper();
}
string material = this.lblmaterialNo.Text.ToString();
DataSet ds = new DataSet();
ds = commBB.Query(" exec [dbo].[up_inventory_OutIn_list] '" + material + "','" + strStartDt + "','" + strEndDt + "'");
this.gridSaleBill.DataSource = ds.Tables[0];
this.gridSaleBill.DataBind();
this.Label1.Text = ds.Tables[0].Rows.Count.ToString();
this.Label4.Text = this.gridSaleBill.PageCount.ToString();
this.TextBox1.Text = (this.gridSaleBill.PageIndex + 1).ToString();
}
catch { }
finally
{
commBB.Dispose();
}
}示例12: btnCommit_Click
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCommit_Click(object sender, EventArgs e)
{
bool retChecked = false;
BBackBillBB backBillBB = new BBackBillBB();
try
{
foreach (GridViewRow gvrow in this.grid.Rows)
{
CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
if (chkId.Checked == true)
{
int id = int.Parse(chkId.ValidationGroup);
BBackBillData backBillModel = backBillBB.GetModel(Convert.ToInt32(id));
if (backBillModel.instantState != "03")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条未提交退货单记录!\");", true);
return;
}
else
{
retChecked = true;
backBillModel.commitDt = System.DateTime.Now.ToString();
backBillModel.commitEmpId = this.currentUser.empId;
backBillModel.instantState = "02";
backBillBB.ModifyRecord(backBillModel);
}
DataTable dtDetail = new DataTable();
BBackDetailBB backDetailBB = new BBackDetailBB();
//获取退货明细数据源
dtDetail = backDetailBB.GetList("backBillNo='" + backBillModel.backBillNo + "'").Tables[0];
string commadPallet = "";
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
if (i == dtDetail.Rows.Count - 1)
{
commadPallet += "BoxNO = '" + dtDetail.Rows[i]["BoxNo"].ToString().ToUpper().Trim() + "'";
}
else
{
commadPallet += "BoxNO = '" + dtDetail.Rows[i]["BoxNo"].ToString().ToUpper().Trim() + "' or ";
}
}
string command = "select distinct palletNo from BArrangeBillBox where " + commadPallet;//获取订单下的托盘号码
SCommBB bb = new SCommBB();
DataTable dt = bb.Query(command).Tables[0];
bb.Dispose();
//BForkliftTaskBC bforkTaskBC = new BForkliftTaskBC();
//for (int j = 0; j < dt.Rows.Count; j++)
//{
// bforkTaskBC.SaveForkliftTaskWithTHD(dt.Rows[j][0].ToString(), "YCQ", "N01.01", "30", this.currentUser.empId,backBillModel.backBillNo);
//}
}
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
backBillBB.Dispose();
}
if (retChecked)
{
this.BindGrid();
}
}示例13: btnUp_Click
protected void btnUp_Click(object sender, EventArgs e)
{
this.lblMsg.Text = "";
this.isUpSucess = false;
if (this.SingleLimit == "1" && this.selectedFiles.Items.Count > 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"本次文件上传只允许选择单个文件!\");", true);
return;
}
int userId = this.currentUser.empId;
int fileID = 0;
string preFileNm = "";
SFileData model = new SFileData();
SSpaceBC spaceBC = new SSpaceBC();
try
{
//判断文件格式（0无限制、1图片）
switch (this.FileType)
{
case "0":
break;
case "1":
FileInfo file = new FileInfo(this.File1.PostedFile.FileName);
string extension = file.Extension;
//查看文件格式是否存在与系统表“图片文件格式”中
SCommBB commBB = new SCommBB();
try
{
if (commBB.Query("select 1 from SImageFileType where fileExtension='" + extension + "'").Tables[0].Rows.Count == 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"本次附件上传要求为图片格式文件，请重新选择!\");", true);
return;
}
}
finally
{
commBB.Dispose();
}
break;
default:
break;
}
fileID = spaceBC.UploadFile(model, this.File1.PostedFile, userId, this.FileType == "1");
if (fileID != 0)
{
preFileNm = model.preFileNm;
}
ListItem item = new ListItem();
item.Text = preFileNm;
item.Value = fileID.ToString();
this.selectedFiles.Items.Add(item);
this.isUpSucess = true;
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",1);", true);
return;
}
finally
{
spaceBC.Dispose();
}
}示例14: ShowPullInfo
//.........这里部分代码省略.........
}
if (roundrectId == 1)
{
nodeType = "start";
fillcolor = "#00EE00";
}
else if (i == ds.Tables[0].Rows.Count - 1 && j == levelDs.Tables[0].Rows.Count - 1)
{
nodeType = "end";
fillcolor = "#F4A8BD";
}
else
{
fillcolor = "#EEEEEE";
}
//����X����
if (Convert.ToInt32(levelRow["coordinateX"]) != 0)
{
coordinateX = Convert.ToInt32(levelRow["coordinateX"]);
}
else
{
if (currLevelSteps > 1)
{
coordinateX = 30 + stepIntervalX * j;
}
else
{
coordinateX = 230;
}
}
//����Y����
if (Convert.ToInt32(levelRow["coordinateY"]) != 0)
{
coordinateY = Convert.ToInt32(levelRow["coordinateY"]);
}
else
{
if (stepLevels > 1)
{
coordinateY = 30 + stepIntervalY * i;
}
else
{
coordinateY = 230;
}
}
vmlStr.Append(" <vml:roundrect inset='2pt,2pt,2pt,2pt' id='" + roundrectId.ToString() + "' stepId='" + stepId + "' nodeType='" + nodeType + "'\r\n");
vmlStr.Append(" readonly='0' fillcolor='" + fillcolor + "' ondblclick='EditStep(" + stepId + ");' style='left: " + coordinateX.ToString() + ";\r\n");
vmlStr.Append(" top: " + coordinateY.ToString() + "; width: 100; position: absolute; height: 50; vertical-align: middle; cursor: hand; text-align: center;\r\n");
vmlStr.Append(" z-index: 1' arcsize='4321f' coordsize='21600,21600' title='��'>\r\n");
vmlStr.Append(" <vml:shadow on='T' type='single' color='#b3b3b3' offset='3px,3px' />\r\n");
vmlStr.Append(" <vml:textbox inset='1pt,2pt,1pt,1pt' onselectstart='return false;'><b>" + stepNo + "-" + seq + "</b><br />" + stepNm + "</vml:textbox>\r\n");
vmlStr.Append(" </vml:roundrect>\r\n");
vmlStr.Append("\r\n");
if (j > 0)
{
//��ͬ������֮������
vmlStr.Append(" <vml:line mfrid='1' title='' source='" + Convert.ToString(roundrectId - 1) + "' object='" + roundrectId.ToString() + "' from='0,0' to='0,0' style='position: absolute;\r\n");
vmlStr.Append(" display: none; z-index: 2' arcsize='4321f' coordsize='21600,21600'>\r\n");
vmlStr.Append(" <vml:shadow on='T' type='single' color='#b3b3b3' offset='1px,1px' />\r\n");
vmlStr.Append(" </vml:line>\r\n");
vmlStr.Append("\r\n");
}
if (j == currLevelSteps / 2)
{
currCenterRoundrectId = roundrectId;
}
roundrectId += 1;
}
if (i > 0)
{
//����ͬ����֮������
vmlStr.Append(" <vml:line mfrid='1' title='' source='" + Convert.ToString(preCenterRoundrectId) + "' object='" + Convert.ToString(currCenterRoundrectId) + "' from='0,0' to='0,0' style='position: absolute;\r\n");
vmlStr.Append(" display: none; z-index: 2' arcsize='4321f' coordsize='21600,21600'>\r\n");
vmlStr.Append(" <vml:stroke endarrow='block'>\r\n");
vmlStr.Append(" </vml:stroke>\r\n");
vmlStr.Append(" <vml:shadow on='T' type='single' color='#b3b3b3' offset='1px,1px' />\r\n");
vmlStr.Append(" </vml:line>\r\n");
vmlStr.Append("\r\n");
}
preCenterRoundrectId = currCenterRoundrectId;
}
}
finally
{
commBB.Dispose();
functionStepBB.Dispose();
}
this.vmlStr = vmlStr;
}示例15: InitPermissionData
/// <summary>
/// 初始化默认权限数据
/// </summary>
private void InitPermissionData()
{
PRolePermissionsBB rolePermissionsBB = new PRolePermissionsBB();
STreeFunctionBB treeFunctionBB = new STreeFunctionBB();
SCommBB commBB = new SCommBB();
try
{
//除了超级管理员，其他用户只能在自己的权限列表范围之内进行分配
if (this.IsHaveRole(1))
{
this.treeFunctionDs = treeFunctionBB.GetList("");
}
else
{
this.treeFunctionDs = commBB.Query("select distinct nodeId,permissionsTypeId,permissionsTypeNo as functionNo,permissionsTypeNm as functionNm from vSTree where empId="
+ this.currentUser.empId.ToString() + " order by permissionsTypeId");
}
//获取岗位具体权限
this.rolePermissionsDs = rolePermissionsBB.GetList("roleId=" + this.RoleId.ToString());
}
finally
{
rolePermissionsBB.Dispose();
treeFunctionBB.Dispose();
commBB.Dispose();
}
}