/// <summary>
/// 直接保存并提交数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Save();
//生成新的工作流实例
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("ReportBoxMonthYearEdit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
CallJsFun("alert('成功保存并提交');");
Response.Redirect("ReportBoxMonthYearList.aspx");
}
catch (Exception ex)
{
ShowJsMessage(ex.Message);
}
}
/// <summary>
/// 提交数据事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
SaveDate();
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_Bank_PreDesign_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
CallJsFun("alert('保存并提交成功.');window.close();");
}
/// <summary>
/// �ύ�����¼�
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
SaveDate();
//�ύ��Ϣ����Ҫ�жϣ��������ͣ������Ҫ�����µĹ�����ʵ��
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//��ͣ״̬�������ύ����ʱ��ֻ��Ҫ��������״̬����"4"ת����"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //�����µĹ�����ʵ��
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("ReportInfo_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //��������Ӧ�Ĺ�����
{
CallJsFun("alert('���ݱ���ɹ�.����������Ӧ���������ã�����ϵ����Ա���Ժ������ύ.');window.close();");
}
else //����һ���������Ʋ���״̬����
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
CallJsFun("alert('���沢�ύ�ɹ�.');window.close();");
}
/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOK_Click(object sender, EventArgs e)
{
string KeyWord = Convert.ToString(Request.QueryString["Guid"]);
string UserGuid = Session["UserID"].ToString();
string UserName = Session["RealName"].ToString();
if (rbPass.Checked)
{
string NextStepName="";
bool IsEnd = new CaseCheck().CheckPass(KeyWord, txtCheckOpion.Text, UserGuid, UserName, out NextStepName);
//，如果是最后一个审批点，更改CAW_ DateStatus中的DATASTATUS和CHECKOPION
if (IsEnd)
{
new CawDataStatusDB().Update(KeyWord, "2", txtCheckOpion.Text,"审批通过");
}
else
{
new CawDataStatusDB().Update(KeyWord, "1", txtCheckOpion.Text, NextStepName);
}
// ShowJsMessage("审批通过成功.");
CallJsFun("alert('审批通过成功.'); window.location='/Pages/MainPage.aspx';");
}
else if (rbBack.Checked)
{
string BackStepName="";
bool IsBegin = new CaseCheck().CheckBack(KeyWord, txtCheckOpion.Text, UserGuid, UserName, out BackStepName);
//如果回退到开始，则需要更改CAW_ DateStatus中的DATASTATUS和CHECKOPION
if (IsBegin)
{
new CawDataStatusDB().Update(KeyWord, "3", txtCheckOpion.Text, "退回");
}
else
{
//应非退回到提交者本人，因此审批意见为空
new CawDataStatusDB().Update(KeyWord, "1", "", BackStepName+ "(退回重审)");
}
// ShowJsMessage("审批回退成功.");
CallJsFun("alert('审批回退成功.'); window.location='/Pages/MainPage.aspx';");
}
else if (rbPause.Checked)
{
bool CanEdit = chbCanEdit.Checked;
new CaseCheck().CheckPause(KeyWord, txtCheckOpion.Text, CanEdit, UserGuid, UserName);
//如果需要修改数据，则将更改CAW_ DateStatus中的DATASTATUS和CHECKOPION
if (CanEdit)
{
new CawDataStatusDB().Update(KeyWord, "4", txtCheckOpion.Text,"(暂停需修改)");
}
// ShowJsMessage("审批暂停成功.");
CallJsFun("alert('审批暂停成功.'); window.location='/Pages/MainPage.aspx';");
}
}
/// <summary>
/// 直接保存并提交数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
SaveDate();
//生成新的工作流实例
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_CompanyBussiness_Edit.aspx", ViewState["Guid"].ToString(), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
CallJsFun("alert('成功保存并提交');window.close();");
}
/// <summary>
/// 保存数据，同时更新数据状态
/// </summary>
protected void SaveDate(int per)
{
string DealGuid = ViewState["Guid"].ToString();
string StartGuid = Request.QueryString["guid"].ToString();
string CompanyGuid = Session["ORGID"].ToString();
string CompanyName = Session["CompanyName"].ToString();
string ShipName = this.txtShipName.Text.Trim();
string Nationnality = this.txtShipNation.Text.Trim();
string Code = this.txtCode.Text.Trim();
string ArriveDate = this.dtxtArriveDate.Text.Trim();
string DealGoodDate = this.dtbDealDate.Text.Trim();
string CargoType = this.rbtCargoType.SelectedItem.Value.Trim();
string TradeType = this.rbtTradeType.SelectedItem.Value.Trim();
string CargoName = this.txtCargoName.Text.Trim();
int CargoPiece = Convert.ToInt32(this.ntbPiece.Text.Trim());
int Empty20 = Convert.ToInt32(this.ntbEmrty20.Text.Trim());
int Empty40 = Convert.ToInt32(this.ntbEmrty40.Text.Trim());
int Empty45 = Convert.ToInt32(this.ntbEmrty45.Text.Trim());
decimal EmptyTotal = Convert.ToDecimal(this.ntbEmrtyTotal.Text.Trim());
int Weighty20 = Convert.ToInt32(this.ntbWeighty20.Text.Trim());
int Weighty40 = Convert.ToInt32(this.ntbWeighty40.Text.Trim());
int Weighty45 = Convert.ToInt32(this.ntbWeighty45.Text.Trim());
decimal WeightyTotal = Convert.ToDecimal(this.ntbWeightyTotal.Text.Trim());
decimal CargoWeigth = this.rbtCargoType.SelectedIndex == 0 ? Convert.ToDecimal(this.ntbWeight.Text.Trim()) : Convert.ToDecimal(this.ntbConWeight.Text.Trim()); ;
decimal ContainerTotal = Convert.ToDecimal(this.ntbContainerTotal.Text.Trim());
string Remark = this.txtREMARK.Text.Trim();
new CawInfoDealGoods().Update(DealGuid, Code, ArriveDate, DealGoodDate, CargoType, TradeType, CargoName, CargoPiece, Empty20, Empty40, Empty45, EmptyTotal, Weighty20, Weighty40, Weighty45, WeightyTotal, CargoWeigth, ContainerTotal, Remark);
//更新数据状态
new CawDataStatusDB().UpdateNoSubmit(DealGuid, Session["UserID"].ToString(), Session["RealName"].ToString());
if (per == 1)
{
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_Info_DealGoods_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
if (CargoType == "1")
this.CallJsFun("javascript:Is_JZX(1);");
}
}
private void SaveData(int oper)
{
string DownHarbour = this.txtDownAdd.Text.Trim();
DateTime EndTime = Convert.ToDateTime(this.dtbEndDate.Text.Trim() + " " + this.ntbEndHour.Text.Trim() + ":" + this.ntbEndMinute.Text.Trim());
DateTime LeaveTime = Convert.ToDateTime(this.dtbLeaveDate.Text.Trim() + " " + this.ntbLeaveHour.Text.Trim() + ":" + this.ntbLeaveMinute.Text.Trim());
//插入值
EndDB.Update(ViewState["Guid"].ToString(), DownHarbour, EndTime, LeaveTime);
if (this.hidDataStatus.Value != "")
new CawDataStatusDB().UpdateNoSubmit(ViewState["Guid"].ToString(), Session["UserID"].ToString(), Session["RealName"].ToString());
else
//插入状态
new CawDataStatusDB().Insert(ViewState["Guid"].ToString(), DateTime.Now, Session["RealName"].ToString(), Session["UserID"].ToString(), "0");
if (oper == 1)
{
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
//生成新的工作流实例
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_End_Add.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
if (this.rbtCargoType.SelectedItem.Value == "1")
this.CallJsFun("javascript:Is_JZX(1);");
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
}
if (this.rbtCargoType.SelectedItem.Value == "1")
this.CallJsFun("javascript:Is_JZX(1);");
}
private void SaveData(int oper)
{
string CompanyGuid = this.ddlCorp.SelectedItem.Value.Trim();
string CompanyName = this.ddlCorp.SelectedItem.Text.Trim();
//船舶信息
string ShipGuid = this.hidShipGuid.Value.Trim();
string ShipName = this.txtShip.Value.Trim();
string BerthGuid = this.ddlBerth.SelectedItem.Value.Trim();
string BerthName = this.ddlBerth.SelectedItem.Text.Trim();
string UpAddress = this.txtUpAdd.Text.Trim();
string WorkType = this.rbtWorkType.SelectedItem.Value.Trim();
DateTime DockTime = Convert.ToDateTime(this.dtbDockTime.Text.Trim() + " " + this.ntbDockHour.Text.Trim() + ":" + this.ntbDockMinute.Text.Trim());
DateTime StartTimie = Convert.ToDateTime(this.dtbStartTime.Text.Trim() + " " + this.ntbStartHour.Text.Trim() + ":" + this.ntbStartMinute.Text.Trim());
//装卸货物信息
string CargoType = this.rbtCargoType.SelectedItem.Value.Trim();
string CargoName = this.txtCargoName.Text.Trim();
int CargoPiece = Convert.ToInt32(this.ntbPiece.Text.Trim());
string CargoClassCode1 = this.rbtCargoType.SelectedIndex == 0 ? (this.ttvCargoClass1.Value.Trim() == "" ? "" : this.ttvCargoClass1.Value.Trim()) : "";
//string CargoClassGuid1 = this.rbtCargoType.SelectedIndex == 0 ? (this.ttvCargoClass1.Value.Trim() == "" ? "" : CCCD.GetGuidByCode(this.ttvCargoClass1.Value.Trim())) : "";
string CargoClassName1 = this.ttvCargoClass1.Text.Trim();
string CargoClassCode2 = this.rbtCargoType.SelectedIndex == 0 ? (this.ttvCargoClass2.Value.Trim() == "" ? "" : this.ttvCargoClass2.Value.Trim()) : "";
//string CargoClassGuid2 = this.rbtCargoType.SelectedIndex == 0 ? CCCD.GetGuidByCode(this.ttvCargoClass2.Value.Trim()) : "";
string CargoClassName2 = this.ttvCargoClass2.Text.Trim();
int Empty20 = Convert.ToInt32(this.ntbEmrty20.Text.Trim());
int Empty40 = Convert.ToInt32(this.ntbEmrty40.Text.Trim());
int Empty45 = Convert.ToInt32(this.ntbEmrty45.Text.Trim());
decimal EmptyTotal = Convert.ToDecimal(this.ntbEmrtyTotal.Text.Trim());
int Weighty20 = Convert.ToInt32(this.ntbWeighty20.Text.Trim());
int Weighty40 = Convert.ToInt32(this.ntbWeighty40.Text.Trim());
int Weighty45 = Convert.ToInt32(this.ntbWeighty45.Text.Trim());
decimal WeightyTotal = Convert.ToDecimal(this.ntbWeightyTotal.Text.Trim());
decimal CargoWeigth = this.rbtCargoType.SelectedIndex == 0 ? Convert.ToDecimal(this.ntbWeight.Text.Trim()) : Convert.ToDecimal(this.ntbConWeight.Text.Trim()); ;
decimal ContainerTotal = Convert.ToDecimal(this.ntbContainerTotal.Text.Trim());
string TradeType = this.rbtTradeType.SelectedItem.Value.Trim();
string UpORDown = this.rbtUpORDown.SelectedItem.Value.Trim();
string InOROut = this.rbtInOROut.SelectedItem.Value.Trim();
string LoadCountry = this.txtLoadCountry.Text.Trim();
string LoadHarbour = this.txtLoadHarbour.Text.Trim();
string UnloadCountry = this.txtUnloadCountry.Text.Trim();
string UnloadHarbour = this.txtUnloadHarbour.Text.Trim();
string AgentGuid = this.ddlAgentCorp.SelectedItem.Value.Trim();
string AgentCorp = this.ddlAgentCorp.SelectedItem.Text.Trim();
string DealgoodsGuid = this.ddlDealgoodsCorp.SelectedItem.Value.Trim();
string DealgoodsCorp = this.ddlDealgoodsCorp.SelectedItem.Text.Trim();
string LoadCorp = this.txtLoadCorp.Text.Trim();
string Is_Agent = ViewState["IS_AGENT"].ToString();
//更新数据
string Guid = Request.QueryString["Guid"].ToString();
StartDB.Update(Guid, CompanyGuid, CompanyName, ShipGuid, ShipName, BerthGuid, BerthName, UpAddress, WorkType, DockTime, StartTimie, CargoType, CargoName, CargoPiece, CargoClassCode1, CargoClassName1, CargoClassCode2, CargoClassName2, Empty20, Empty40, Empty45, EmptyTotal, Weighty20, Weighty40, Weighty45, WeightyTotal, CargoWeigth, ContainerTotal, TradeType, UpORDown, InOROut, LoadCountry, LoadHarbour, UnloadCountry, UnloadHarbour, AgentGuid, AgentCorp, DealgoodsGuid, DealgoodsCorp, LoadCorp, Is_Agent);
//更新数据状态
new CawDataStatusDB().UpdateNoSubmit(Guid, Session["UserID"].ToString(), Session["RealName"].ToString());
if (oper == 1)
{
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_Start_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
}
if (CargoType == "1")
this.CallJsFun("javascript:Is_JZX(1);");
}
/// <summary>
/// 保存数据，同时更新数据状态
/// </summary>
protected void SaveDate(int per)
{
string Guid = ViewState["Guid"].ToString();
string ShipGuid = this.hidShipGuid.Value.Trim();
string CompanyGuid = Session["ORGID"].ToString();
string CompanyName = Session["CompanyName"].ToString();
string ShipNameCN = this.txtShipNameCN.Text.Trim();
string ShipNameEN = this.txtSHIPNAMEEN.Text.Trim();
string CallLetter = this.txtCALLLETTER.Text.Trim();
string Owner = this.txtOWNER.Text.Trim();
int BuildDate = Convert.ToInt16(this.ntbYearNum.Text.ToString());
string Nationnality = this.txtNationality.Text.Trim();
int ShipType = this.ddlShipType.SelectedIndex == 0 ? -1 : Convert.ToInt16(this.ddlShipType.SelectedItem.Value.Trim());
string ShipTypeName = this.ddlShipType.SelectedItem.Text.Trim();
int ShipHoist = this.ntbShipHoist.Text.Trim() == "" ? 0 : Convert.ToInt16(this.ntbShipHoist.Text.Trim());
int ShipHold = this.ntbShipHold.Text.Trim() == "" ? 0 : Convert.ToInt16(this.ntbShipHold.Text.Trim());
decimal TotalTon = this.ntxtTOTALTON.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtTOTALTON.Text.Trim());
decimal NetTon = this.ntxtNETTON.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtNETTON.Text.Trim());
decimal LoadTon = this.ntxtLOADTON.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtLOADTON.Text.Trim());
decimal ShipLength = this.ntxtSHIPLENGTH.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtSHIPLENGTH.Text.Trim());
decimal ShipWidth = this.ntxtSHIPWIDTH.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtSHIPWIDTH.Text.Trim());
decimal Depth = this.ntxtDEPTH.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtDEPTH.Text.Trim());
string GoodsInfo = this.txtGOODSINFO.Text.Trim();
string FeeInfo = this.txtFEEINFO.Text.Trim();
decimal Length = this.ntxtLENGTH.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtLENGTH.Text.Trim());
decimal LollDepth = this.ntxtLOLLDEPTH.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtLOLLDEPTH.Text.Trim());
decimal Height = this.ntxtHEIGHT.Text.Trim() == "" ? 0 : Convert.ToDecimal(this.ntxtHEIGHT.Text.Trim());
string ShipMenNationnality = this.txtSHIPMENNATIONNALITY.Text.Trim();
string PortGuid = this.ddlCorp.SelectedItem.Value.Trim();
string PortName = this.ddlCorp.SelectedItem.Text.Trim();
string BerthGuid = this.ddlBerth.SelectedItem.Value.Trim();
string BerthName = this.ddlBerth.SelectedItem.Text.Trim();
string LoadHarbour = this.txtLOADHARBOUR.Text.Trim();
string UnLoadHarbour = this.txtUNLOADHARBOUR.Text.Trim();
string PrevionsHarbour = this.txtPREVIOUSHARBOUR.Text.Trim();
string NextHarbour = this.txtNEXTHARBOUR.Text.Trim();
DateTime ArriveYangtseRiverDate = this.dtbARRIVEDATE.Text.Trim() == "" ? DateTime.MinValue : Convert.ToDateTime(this.dtbARRIVEDATE.Text.Trim() + " " + this.ntbArriveHour.Text.Trim() + ":" + this.ntbArriveMinute.Text.Trim());
DateTime ArriveZJGDate = this.dtbARRIVEZJGDATE.Text.Trim() == "" ? DateTime.MinValue : Convert.ToDateTime(this.dtbARRIVEZJGDATE.Text.Trim() + " " + this.ntbZJGHour.Text.Trim() + ":" + this.ntbZJGMinute.Text.Trim());
string DealGoodsCMPGuid = this.ddlDealGoodsCmp.SelectedIndex == 0 ? "" : this.ddlDealGoodsCmp.SelectedItem.Value.Trim();
string DealGoodsCMPName = this.ddlDealGoodsCmp.SelectedItem.Text.Trim();
AgentShipDB.Update(Guid, ShipGuid, CompanyGuid, CompanyName, ShipNameCN, ShipNameEN, CallLetter, Owner, BuildDate, Nationnality,
ShipType, ShipTypeName, ShipHoist, ShipHold, TotalTon, NetTon, LoadTon, ShipLength, ShipWidth, Depth, GoodsInfo,
FeeInfo, Length, LollDepth, Height, ShipMenNationnality, PortGuid, PortName, BerthGuid, BerthName, LoadHarbour,
UnLoadHarbour, PrevionsHarbour, NextHarbour, ArriveYangtseRiverDate, ArriveZJGDate, DealGoodsCMPGuid, DealGoodsCMPName);
//更新数据状态
new CawDataStatusDB().UpdateNoSubmit(Guid, Session["UserID"].ToString(), Session["RealName"].ToString());
if (per == 1)
{
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_Info_AgentShipInfo_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
}
}
private void SaveInfo(int oper)
{
string CompanyGuid = this.lblCompanyGuid.Text.Trim();
string CompanyName = this.lblCompanyName.Text.Trim();
string YearNum = this.ddlYear.SelectedItem.Text.Trim();
string DivSave = this.hidHTML.Value.Trim();
string SumUp = this.TextBox67.Text.Trim();
//更新值
new CawPortManageDB().Update(ViewState["Guid"].ToString(), CompanyGuid, CompanyName, YearNum, DivSave, SumUp);
//更新数据状态
new CawDataStatusDB().UpdateNoSubmit(ViewState["Guid"].ToString(), Session["UserID"].ToString(), Session["RealName"].ToString());
if (oper == 1)
{
//提交信息，需要判断，如果是暂停，则不需要生产新的工作流实例
if (Convert.ToString(ViewState["CurrStatus"]) == "4")
{
//暂停状态，重新提交数据时，只需要更新数据状态，从"4"转换成"1"
new CawDataStatusDB().Update(Convert.ToString(ViewState["Guid"]), "1");
}
else //生成新的工作流实例
{
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_PortManage_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
}
}
private void MyCheckItems()
{
DataView dvList =new CaseCheck().GetMyCheckItems(Convert.ToString(Session["UserID"])).DefaultView;
if (dvList.Count > 0)
{
this.DataGrid1.DataSource = dvList;
this.DataGrid1.DataBind();
}
else
{
this.CallJsFun("document.all[\"tdCheck\"].style.display = 'none';");
}
}
/// <summary>
///
/// 编写日期：2010-3-12
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
/// <param name="DATASTATUS"></param>
public int Update(string PageName,string GUID,string SubmitUserID,string SubmitUserName, string CorGuid,string CorName,string DATASTATUS,bool IsPause)
{
string FirstStepName = "";
if (!IsPause)
{
bool flag = new CaseCheck().InsertCase(PageName, GUID, SubmitUserID, SubmitUserName, CorGuid, CorName, out FirstStepName);
if (flag == false)
{
return 0;
}
}
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"UPDATE CAW_DATESTATUS SET DATASTATUS=@DATASTATUS,DATASTATUS_NAME=@DATASTATUS_NAME,SUBMITUSERNAME=@SUBMITUSERNAME,SUBMITUSERID=@SUBMITUSERID,SUBMITDATE=@SUBMITDATE WHERE KEYGUID=@GUID " :
"UPDATE CAW_DATESTATUS SET DATASTATUS=:DATASTATUS,DATASTATUS_NAME=:DATASTATUS_NAME,SUBMITUSERNAME=:SUBMITUSERNAME,SUBMITUSERID=:SUBMITUSERID,SUBMITDATE=:SUBMITDATE WHERE KEYGUID=:GUID ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "DATASTATUS", DbType.String, DATASTATUS);
db.AddInParameter(cmd, "DATASTATUS_NAME", DbType.String, FirstStepName);
db.AddInParameter(cmd, "SUBMITUSERNAME", DbType.String, SubmitUserName);
db.AddInParameter(cmd, "SUBMITUSERID", DbType.String, SubmitUserID);
db.AddInParameter(cmd, "SUBMITDATE", DbType.DateTime, DateTime.Now);
db.AddInParameter(cmd, "GUID", DbType.String, GUID);
strSql = GetSqlStr(strSql, cmd);
new FrameLog().InsertLog(OPERATION_TYPE.LOG_MODIFY, "审批状态", "更新审批状态，编码为" + strSql, "CAW_DATESTATUS");
return db.ExecuteNonQuery(cmd);
}
public DataView GetWaiteItems(string UserID)
{
CaseCheck CC = new CaseCheck();
List<OA_SWFCASE> SCList = CC.GetMyCheck(UserID);
DataTable tab = new DataTable();
tab.Columns.Add("SEQ", typeof(System.Int32));
tab.Columns.Add("TITLE", typeof(System.String));
tab.Columns.Add("SUBMITORGNAME", typeof(System.String));
tab.Columns.Add("SUBMITDATE", typeof(System.String));
tab.Columns.Add("URL", typeof(System.String));
tab.Columns.Add("SUBMITORGID", typeof(System.String));
for (int i = 0; i < SCList.Count; i++)
{
DataRow dr = tab.NewRow();
dr[0] = Convert.ToString(i + 1);
dr[1] = SCList[i].CASETITLE;
dr[2] = SCList[i].SUBMITORGNAME;
dr[3] = SCList[i].SUBMITDATE.ToString();
dr[4] = "/Projects/ZJGEportDocManage/Approval/CheckForm.aspx?Guid=" + SCList[i].FORMKEY;
dr[5] = SCList[i].SUBMITORGID;
tab.Rows.Add(dr);
}
return tab.DefaultView;
}
private void SaveInfo(int oper)
{
string DivSave = hidHTML.Value;//str即为所需值。
string CompanyGuid = this.lblCompanyGuid.Text.Trim();
string CompanyName = this.txtPortOperator.Text.Trim();
string YearNum = this.ddlYear.SelectedItem.Text.Trim();
string SunUp = this.TextBox67.Text.Trim();
// string DivSave = spanSave.InnerHtml.Replace("'", "★");
//插入值
new CawPortManageDB().Insert(ViewState["Guid"].ToString(), CompanyGuid, CompanyName, YearNum, DivSave, SunUp);
//插入状态
new CawDataStatusDB().Insert(ViewState["Guid"].ToString(), DateTime.Now, Session["RealName"].ToString(), Session["UserID"].ToString(), "0");
if (oper == 1)
{
//生成新的工作流实例
string FirstStepName = "";
bool HasFlow = new CaseCheck().InsertCase("Caw_PortManage_Edit.aspx", Convert.ToString(ViewState["Guid"]), Convert.ToString(Session["UserID"]),
Convert.ToString(Session["RealName"]), Convert.ToString(Session["ORGID"]),
Convert.ToString(Session["CompanyName"]), out FirstStepName);
if (!HasFlow) //不存在相应的工作流
{
CallJsFun("alert('数据保存成功.但不存在相应的审批配置，请联系管理员或稍候重新提交.');window.close();");
}
else //将第一个步骤名称插入状态表中
{
new CawDataStatusDB().UpdateStepName(Convert.ToString(ViewState["Guid"]), "1", FirstStepName);
}
}
}