/// <summary>
/// 导出EXcel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnZToNewExcel_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
string CompactNo = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "CompactNo"));
string ColorName = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ColorName"));
string JarNum = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "JarNum"));
string OtherSO = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "OtherSO"));
string p_ExportFile = string.Empty;
CheckOrderISNRule rule = new CheckOrderISNRule();
GetCondtion();
HTDataConditionStr += " AND CompactNo=" + SysString.ToDBString(CompactNo) + " AND ColorName=" + SysString.ToDBString(ColorName) + " AND JarNum=" + SysString.ToDBString(JarNum) + " AND Seq>0 " + " AND ISNULL(OtherSO,'')=" + SysString.ToDBString(OtherSO);
HTDataConditionStr += " ORDER BY CompactNo,JarNum, JarNumCount ASC";//
//DataTable dttem = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("CheckFlag", "0 CheckFlag").Replace("PF", "0.00 PF"));
//TemplateExcel.JYToExcel(dttem, out p_ExportFile);
//this.OpenFileNoConfirm(p_ExportFile);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
CheckOrderISNRule rule = new CheckOrderISNRule();
gridView1.Columns["CheckFlag"].OptionsColumn.ReadOnly = false;
gridView1.Columns["CheckFlag"].OptionsColumn.AllowEdit = true;
gridView1.Columns["CheckFlag"].OptionsColumn.AllowFocus = true;
HTDataConditionStr += " ORDER BY JarNum, Seq ASC";//JarNumCount
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("CheckFlag", "0 CheckFlag"));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
private void btnDelete_Click_1(object sender, EventArgs e)
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.除))
{
this.ShowMessage("你没有此操作权限");
return;
}
if (MessageBox.Show("确定要删除这匹布吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("DID"));
CheckOrderISN entity = new CheckOrderISN();
entity.ID = ID;
entity.SelectByID();
if (entity.StatusID > (int)EnumBoxStatus.未入库)
{
this.ShowMessage("布匹已经入库，请检查");
return;
}
//if (entity.KF25 == 1)
//{
// this.ShowMessage("开匹的数据不能删除");
// return;
//}
//if (entity.KF22 == 1)
//{
// this.ShowMessage("退货冲销修改的数据不能删除");
// return;
//}
CheckOrderISNRule rule = new CheckOrderISNRule();
rule.RDelete(entity);
btnQuery_Click(null, null);
}
