public int Del()
{
string sSql = "exec [dbo].[Delete_Run] " + this.Id.ToString();
int rows = XSql.Execute(sSql);
return(rows);
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string flowId = string.Empty;
if (chkAllFlow.Checked == true)
{
flowId = "0";
}
else
{
flowId = this.ddlFlowName.SelectedItem.Value;
}
string principal = this.hidden_Principal.Value;
string beThePrincipal = this.hidden_BeThePrincipal.Value;
string startTime = "null";
string endTime = "null";
int status = 1; //1表示委托状态 0表示不是委托状态
if (!string.IsNullOrEmpty(this.txtStartTime.Text))
{
startTime = String.Format("'{0}'", this.txtStartTime.Text);
}
if (!string.IsNullOrEmpty(this.txtEndTime.Text))
{
endTime = String.Format("'{0}'", this.txtEndTime.Text);
}
//3.验证用户变量，包含Request.QueryString及Request.Form
//4.业务处理过程
string cmdText = "INSERT INTO FL_FlowAuthorization (FlowId,FromUserId,ToUserId,BeginDate,EndDate,Status) VALUES (" + flowId + ",'" + principal + "','" + beThePrincipal + "'," + startTime + "," + endTime + "," + status + ")";
int row = XSql.Execute(cmdText);
//5.（用户及业务对象）统计与状态
//6.登记日志
if (row > 0)
{
XSql.Execute("exec dbo.Main_RefreshFlowAuthorizationState");
WX.Main.AddLog(WX.LogType.Default, "委托添加成功！", null);
}
//7.返回处理结果或返回其它页面。
if (row > 0)
{
ULCode.Debug.Alert("委托添加成功！", "Work_DelegateList.aspx");
}
else
{
ULCode.Debug.Alert("委托添加失败！", "Work_DelegateList.aspx");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
this.PermissionNum = WX.Main.GetPermission(true);
if (this.PermissionNum == -1)
{
context.Response.Write("-1");
context.Response.End();
return;
}
this.A_Del = this.PermissionNum >= Convert.ToInt32(PermissionType.Del);
//1.验证当前用户页面权限
if (!A_Del)
{
context.Response.Write("-2");
context.Response.End();
return;
}
else
{
//2.获取用户变量
string action = context.Request.QueryString["action"];
//3.验证用户变量
int id = WX.Request.rDepartmentId;
int companyID = WX.Request.rCompanyId;
//4.处理业务
if (action == "delete")
{
string sql = String.Format("Select * from tu_Employees where DepartmentID={0}", id);
if (ULCode.QDA.XSql.IsHasRow(sql))
{
context.Response.Write("-3");
context.Response.End();
return;
}
sql = "DELETE FROM TE_Departments WHERE CompanyId=" + companyID + " AND ID=" + id;
System.Diagnostics.Debug.WriteLine(sql);
int row = XSql.Execute(sql);
//5.（用户及业务对象）统计与状态
if (row > 0)
{
WX.Model.Department.GetCache(id).RemoveFromCaches();
//6.登记日志
WX.Main.AddLog(LogType.Default, "部门信息删除成功！", "");
//7.返回页面
context.Response.Write("0");
}
else
{
context.Response.Write("1");
}
}
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string supplierId = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM Ass_Suppliers WHERE SupplierID=" + supplierId);
if (row > 0)
{
ULCode.Debug.Alert("供应商信息删除成功！", "SupplierList.aspx");
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string manageId = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM Fl_FlowManage WHERE Id=" + manageId);
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "权限管理删除成功！", null);
ULCode.Debug.Alert("管理权限删除成功！", "Flow_Priv.aspx?FlowID=" + WX.Request.rFlowID);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string flowId = Request.QueryString["Id"];
string manageType = this.ddlManageType.SelectedItem.Value;
string userList = this.hidden_UserList.Value;
string deptList = string.Empty;
string dutyList = this.hidden_RoleList.Value;
string scope = ddlScope.SelectedItem.Value;
if (ddlScope.SelectedItem.Value == "CUSTOM")
{
deptList = this.hidden_AllDepartment.Value;
}
else
{
deptList = this.hidden_DepartmentList.Value;
}
//3.验证用户变量，包含Request.QueryString及Request.Form
if (!ULCode.Validation.IsNumber(Request.QueryString["Id"]))
{
ULCode.Debug.we("你没有权限访问此功能！");
return;
}
//4.业务处理过程
string cmdText = "UPDATE Fl_FlowManage SET ManageType=" + manageType + ",Scope='" + scope + "',UserList='" + userList + "',DeptList='" + deptList + "',DutyList='" + dutyList + "' WHERE Id=" + Request.QueryString["ManageId"];
int row = 0;
row = XSql.Execute(cmdText);
//填写主要业务逻辑代码
//5.（用户及业务对象）统计与状态
//6.登记日志
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "管理权限修改成功！", null);
}
//7.返回处理结果或返回其它页面。
if (row > 0)
{
ULCode.Debug.Alert("管理权限修改成功！", "Flow_Priv.aspx?id=" + flowId);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string departmentId = this.ddlDepartment.SelectedItem.Value;
string userId = this.hidden_ddlUser.Value;
string inputDate = this.txtInputDate.Text.Trim();
string productId = this.txtProductID.Text.Trim();
string price = this.txtPrice.Text.Trim();
string unit = this.txtUnit.Text.Trim();
string quantity = this.txtQuantity.Text.Trim();
string remark = this.txtRemark.Text.Trim();
//3.验证用户变量，包含Request.QueryString及Request.Form
//4.业务处理过程
Equipment.MODEL equipmentModel = Equipment.NewDataModel();
equipmentModel.DepartmentID.value = departmentId;
equipmentModel.UserID.value = userId;
equipmentModel.AddDate.value = inputDate;
equipmentModel.ProductID.value = productId;
equipmentModel.Price.value = price;
equipmentModel.Unit.value = unit;
equipmentModel.Quantity.value = quantity;
equipmentModel.Remark.value = remark;
//填写主要业务逻辑代码
int row = equipmentModel.Save();
//5.（用户及业务对象）统计与状态
if (row > 0)
{
XSql.Execute("EXEC Assets_AddConsuming " + this.PID.Value + "," + this.txtQuantity.Text + ",'" + this.txtProductID.Text + "'");
//6.登记日志
WX.Main.AddLog(LogType.Default, "个人装备录入成功！", null);
//7.返回处理结果或返回其它页面。
ULCode.Debug.Alert("个人装备录入成功！", "Ass_EquipmentList.aspx");
}
else
{
ULCode.Debug.Alert("个人装备录入失败！", "Ass_EquipmentList.aspx");
}
}
protected void btnSave_Click1(object sender, EventArgs e)
{
string type = "归还";
string opUserID = this.txtOpUserID.Value;
string opTime = this.txtOpTime.Text.Trim();
string opIP = Request.UserHostAddress;
string userId = this.hidden_ddlUser.Value;
string departmentId = this.ddlDepartment.SelectedItem.Value;
string quantity = this.txtQuantity.Text.Trim();
string productID = this.txtProductID.Text.Trim();
string content = this.txtRemarks.Text.Trim();
string unit = this.txtUnit.Text.Trim();
string price = this.txtPrice.Text.Trim();
WX.Ass.Log.MODEL logModel = WX.Ass.Log.NewDataModel();
logModel.Type.value = type;
logModel.OpUserID.value = opUserID;
logModel.OpTime.value = opTime;
logModel.OpIP.value = opIP;
logModel.UserID.value = userId;
logModel.DepartmentID.value = departmentId;
logModel.Quantity.value = quantity;
logModel.ProductID.value = productID;
logModel.Content.value = content;
logModel.Unit.value = unit;
logModel.Price.value = price;
int singleRow = logModel.Save();
int row = 0;
if (singleRow > 0)
{
if (this.PID.Value != "0")
{
XSql.Execute("EXEC Assets_UpdateQuantity " + this.PID.Value + "," + this.txtQuantity.Text + ", '" + this.txtProductID.Text + "','---" + content + "'");
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "产品归还成功！", null);
}
}
}
if (singleRow > 0)
{
ULCode.Debug.Confirm("产品归还成功！", "Ass_ReturnAssets.aspx", "Ass_ConsumingList.aspx");
}
else
{
ULCode.Debug.Alert("产品归还失败！", "Ass_ReturnAssets.aspx");
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string id = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM Fl_FlowAuthorization WHERE Id=" + id);
if (row > 0)
{
WX.Main.AddLog(LogType.Default, "工作委托删除成功！", null);
ULCode.Debug.Alert("工作委托删除成功！", "Work_DelegateList.aspx");
}
else
{
ULCode.Debug.Alert("工作委托删除成功！", "Work_DelegateList.aspx");
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string id = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM CTR_Contracts WHERE ID=" + id);
if (row > 0)
{
WX.Main.AddLog(LogType.Default, "合同删除成功！", null);
ULCode.Debug.Alert("合同删除成功！", "ContractList.aspx");
}
else
{
ULCode.Debug.Alert("合同删除失败！", "ContractList.aspx");
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string id = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM CTR_ContractProduct WHERE ID=" + id);
if (row > 0)
{
ULCode.Debug.Alert("合同产品删除成功！", "AddContractProduct.aspx?ContractID=" + WX.Request.rContractID);
WX.Main.AddLog(LogType.Default, "合同产品删除成功！", null);
}
else
{
ULCode.Debug.Alert("合同产品删除失败！", "AddContractProduct.aspx?ContractID=" + WX.Request.rContractID);
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string id = e.CommandArgument.ToString();
int row = XSql.Execute("DELETE FROM Fl_FlowTimer WHERE Id=" + id);
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "定时设置删除成功！", null);
ULCode.Debug.Alert("定时设置删除成功！", "Flow_Timer.aspx?FlowID=" + WX.Request.rFlowID);
}
else
{
ULCode.Debug.Alert("定时设置删除失败！", "Flow_Timer.aspx?FlowID=" + WX.Request.rFlowID);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string type = "出售";
string opUserID = this.txtOpUserID.Value;
string opTime = this.txtOpTime.Text.Trim();
string opIP = Request.UserHostAddress;
string quantity = this.txtQuantity.Text.Trim();
string productID = this.txtProductID.Text.Trim();
string content = this.txtRemarks.Text.Trim();
string unit = this.txtUnit.Text.Trim();
string price = this.txtPrice.Text.Trim();
WX.Ass.Log.MODEL logModel = WX.Ass.Log.NewDataModel();
logModel.Type.value = type;
logModel.OpUserID.value = opUserID;
logModel.OpTime.value = opTime;
logModel.OpIP.value = opIP;
logModel.Quantity.value = quantity;
logModel.ProductID.value = productID;
logModel.Content.value = content;
logModel.Unit.value = unit;
logModel.Price.value = price;
int singleRow = logModel.Save();
int row = 0;
if (singleRow > 0)
{
if (this.PID.Value != "0")
{
XSql.Execute("EXEC Assets_ProductSales " + this.PID.Value + "," + this.txtQuantity.Text.Trim());
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "产品出售成功！", null);
}
}
}
if (singleRow > 0)
{
ULCode.Debug.Confirm("产品出售成功！", "Ass_ProductSales.aspx", "Ass_LogList.aspx");
}
else
{
ULCode.Debug.Alert("产品出售失败！", "Ass_ProductSales.aspx");
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string id = e.CommandArgument.ToString();
string sSql = "DELETE FROM CRM_ContactTemp WHERE ID=" + id;
int row = XSql.Execute(sSql);
if (row > 0)
{
WX.CRM.Customer.MODEL customer = WX.CRM.Customer.NewDataModel(WX.Request.rCustomerID);
WX.CRM.Customer.AddLog(customer.ID.ToInt32(), customer.CustomerName.ToString(), WX.Main.CurUser.UserID, 10, "删除未审核的联系人");
WX.Main.AddLog(WX.LogType.Default, "客户联系人信息删除成功！", null);
ULCode.Debug.Alert("联系人信息删除成功！", "Crm_Single_AddContact.aspx?PageMode=" + Request["PageMode"] + "&Action=Add&CustomerID=" + WX.Request.rCustomerID);
}
else
{
ULCode.Debug.Alert("联系人信息删除失败！", "Crm_Single_AddContact.aspx?PageMode=" + Request["PageMode"] + "&Action=Add&CustomerID=" + WX.Request.rCustomerID);
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
string productId = e.CommandArgument.ToString();
if (ULCode.QDA.XSql.IsHasRow("SELECT * FROM Ass_Logs WHERE ProductID='" + productId + "'"))
{
ULCode.Debug.Alert(this, "此产品已经应用不能删除！", "Ass_AssetsList.aspx");
return;
}
string id = e.CommandArgument.ToString();
int row = XSql.Execute(String.Format("DELETE FROM Ass_Warehouse WHERE ID='{0}'", id));
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "产品信息删除成功！", null);
ULCode.Debug.Alert(this, "产品信息删除成功！", "Ass_AssetsList.aspx");
}
}
public static void AddLog(int logTypeID, string title, string parameters)
{
string tableName = (string)XSql.GetValue("SELECT TableName FROM TL_LogType WHERE ID=" + logTypeID);
string param = parameters;
string userId = Authentication.GetUserID();
if (string.IsNullOrEmpty(param))
{
param = "NULL";
}
else
{
param = String.Format("'{0}'", param);
}
if (!string.IsNullOrEmpty(tableName))
{
string cmdText = String.Format("INSERT INTO " + tableName + " (Title,UserID,LogType,LogTime,LogIP,LogParaments) VALUES ('{0}','{1}',{2},'{3}','{4}',{5})", title, userId, logTypeID, DateTime.Now, HttpContext.Current.Request.UserHostAddress, param);
XSql.Execute(cmdText);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证当前用户页面权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string contractId = this.lblContractID.Text.Trim();
string productName = this.txtProductName.Text.Trim();
string specification = this.txtSpecification.Text.Trim();
string units = this.ddlUnits.SelectedItem.Text.Trim();
string price = this.txtPrice.Text.Trim();
string quantity = this.txtQuantity.Text.Trim();
string remark = this.txtRemark.Text.Trim();
decimal amount = Convert.ToDecimal(Convert.ToInt32(quantity) * Convert.ToDecimal(price));
//3.验证用户变量，包含Request.QueryString及Request.Form
//4.业务处理过程
string cmdText = "INSERT INTO CTR_ContractProduct (ContractID,ProductName,Specification,Units,Price,Quantity,Amount,Remark) VALUES ('" + contractId + "','" + productName + "','" + specification + "','" + units + "'," + Convert.ToDecimal(price) + "," + quantity + "," + amount + ",'" + remark + "')";
//填写主要业务逻辑代码
int row = XSql.Execute(cmdText);
//5.（用户及业务对象）统计与状态
if (row > 0)
{
//6.登记日志
WX.Main.AddLog(LogType.Default, "合同产品录入成功！", null);
//7.返回处理结果或返回其它页面。
ULCode.Debug.Alert("合同产品录入成功！", "AddContractProduct.aspx?ContractID=" + WX.Request.rContractID);
}
else
{
ULCode.Debug.Alert("合同产品录入失败！", "AddContractProduct.aspx?ContractID=" + WX.Request.rContractID);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
this.PermissionNum = WX.Main.GetPermission(true);
if (this.PermissionNum == -1)
{
context.Response.Write("-1");
context.Response.End();
return;
}
this.A_Del = this.PermissionNum >= Convert.ToInt32(PermissionType.Del);
//1.验证当前用户页面权限
if (!A_Del)
{
context.Response.Write("-2");
context.Response.End();
return;
}
else
{
//2.获取用户变量
string param = "";
int companyID = 0;
//3.验证用户变量
if (string.IsNullOrEmpty(context.Request["param"]))
{
return;
}
if (!int.TryParse(context.Request.QueryString["companyId"], out companyID))
{
return;
}
//4.处理业务
param = context.Request.QueryString["param"];
string[] myParam = param.Split(',');
int row = 0;
foreach (string str in myParam)
{
if (Membership.DeleteUser(WXUser.GetUserNameByUserID(str)))
{
string cmdText = "DELETE FROM TU_Users WHERE UserID IN ('" + str + "')";
//System.Diagnostics.Debug.WriteLine(cmdText);
int iR = XSql.Execute(cmdText);
//if (iR > 0)
//{
XSql.Execute("DELETE FROM TU_Employees WHERE UserID IN ('" + str + "')");
//WX.Model.Employee.GetModelToID(str).RemoveFromCaches();
//}
row += iR;
}
}
if (row > 0)
{
//6.登记日志
WX.Main.AddLog(LogType.Default, String.Format("员工信息删除成功！共选择{0}个，删除{1}个", myParam.Length, row), param);
//7.返回页面
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string timerId = Request.QueryString["timerId"];
string flowId = this.ddlFlowName.SelectedItem.Value;
string userList = this.hidden_SponsorList.Value;
int remindType = Convert.ToInt32(this.ddlRemindType.SelectedItem.Value);
string dateTime = DateTime.Now.ToString();
switch (remindType)
{
case 1:
dateTime = this.txtTimer1.Text;
break;
case 2:
dateTime = String.Format("{0:yyyy-MM-dd} {1}", DateTime.Now, this.txtTimer2.Text);
if (Convert.ToDateTime(dateTime) < DateTime.Now)
{
dateTime = String.Format("{0:yyyy-MM-dd HH:mm}", Convert.ToDateTime(dateTime).AddDays(1));
}
break;
case 3:
dateTime = GetRemindTime(3).ToString();
break;
case 4:
dateTime = GetRemindTime(4).ToString();
break;
case 5:
dateTime = GetRemindTime(5).ToString();
break;
}
//3.验证用户变量，包含Request.QueryString及Request.Form
//4.业务处理过程
//填写主要业务逻辑代码
string sql = "UPDATE Fl_FlowTimer SET FlowId=" + flowId + ",UserList='" + userList + "',RemindType=" + remindType + ",RemindTime='" + dateTime + "' WHERE Id=" + timerId;
int row = XSql.Execute(sql);
//6.登记日志
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "修改定时设置成功！", null);
}
//7.返回处理结果或返回其它页面。
if (row > 0)
{
ULCode.Debug.Alert("定时设置修改成功！", "Flow_Timer.aspx?id=" + flowId);
}
else
{
ULCode.Debug.Alert("提醒类型修改失败", "Flow_Timer.aspx?id=" + flowId);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string flowId = this.ddlFlowName.SelectedItem.Value;
string userList = this.hidden_SponsorList.Value;
int remindType = Convert.ToInt32(this.ddlRemindType.SelectedItem.Value);
string dateTime = DateTime.Now.ToString();
switch (remindType)
{
case 1:
dateTime = this.txtTimer1.Text;
break;
case 2:
dateTime = String.Format("{0:yyyy-MM-dd} {1}", DateTime.Now, this.txtTimer2.Text);
break;
case 3:
dateTime = GetRemindTime(3).ToString();
break;
case 4:
dateTime = GetRemindTime(4).ToString();
break;
case 5:
dateTime = GetRemindTime(5).ToString();
break;
}
//3.验证用户变量，包含Request.QueryString及Request.Form
//4.业务处理过程
//填写主要业务逻辑代码
string cmdText = "SELECT RemindType FROM Fl_FlowTimer WHERE RemindType=" + remindType + " AND FlowId=" + flowId;
if (XSql.IsHasRow(cmdText))
{
ULCode.Debug.Alert("此提醒类型已经添加，不能重复添加", "Flow_Timer.aspx?id=" + flowId);
Response.End();
}
string sql = "INSERT INTO Fl_FlowTimer (FlowId,UserList,RemindType,RemindTime) VALUES (" + flowId + ",'" + userList + "'," + remindType + ",'" + dateTime + "')";
int row = XSql.Execute(sql);
//6.登记日志
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "添加定时设置成功！", null);
}
//7.返回处理结果或返回其它页面。
if (row > 0)
{
ULCode.Debug.Alert("定时设置添加成功！", "Flow_Timer.aspx?id=" + flowId);
}
else
{
ULCode.Debug.Alert("提醒类型添加失败", "Flow_Timer.aspx?id=" + flowId);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.取得用户变量
string flowId = Request.QueryString["Id"];
string manageType = this.ddlManageType.SelectedItem.Value;
string userList = this.hidden_UserList.Value;
string deptList = string.Empty;
string dutyList = this.hidden_RoleList.Value;
string scope = ddlScope.SelectedItem.Value;
if (ddlScope.SelectedItem.Value == "CUSTOM")
{
deptList = this.hidden_AllDepartment.Value;
}
else
{
deptList = this.hidden_DepartmentList.Value;
}
//3.验证用户变量，包含Request.QueryString及Request.Form
if (!ULCode.Validation.IsNumber(Request.QueryString["Id"]))
{
ULCode.Debug.we("你没有权限访问此功能！");
return;
}
//4.业务处理过程
string cmdText = "INSERT INTO Fl_FlowManage(FlowId,ManageType,Scope,UserList,DeptList,DutyList) VALUES (" + flowId + "," + manageType + ",'" + scope + "','" + userList + "','" + deptList + "','" + dutyList + "')";
int row = 0;
bool b = false;
DataTable table = XSql.GetDataTable("SELECT ManageType FROM Fl_FlowManage WHERE FlowId=" + flowId);
b = table.AsEnumerable().Any(f => f.Field <Byte>("ManageType") == Convert.ToByte(this.ddlManageType.SelectedItem.Value));
if (b == true)
{
ULCode.Debug.Alert("此授权类型已经添加过，不能重复添加！", "Flow_Priv.aspx?id=" + flowId);
return;
}
else
{
row = XSql.Execute(cmdText);
}
//填写主要业务逻辑代码
//5.（用户及业务对象）统计与状态
//6.登记日志
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "管理权限添加成功！", null);
}
//7.返回处理结果或返回其它页面。
if (row > 0)
{
ULCode.Debug.Alert("管理权限添加成功！", "Flow_Priv.aspx?id=" + flowId);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string type = "领用";
string opUserID = this.txtOpUserID.Value;
string opTime = this.txtOpTime.Text.Trim();
string opIP = Request.UserHostAddress;
string userId = this.hidden_ddlUser.Value;
string departmentId = this.ddlDepartment.SelectedItem.Value;
//string deadline = this.txtDeadline.Text.Trim();
string maturityDate = this.hidden_MaturityDate.Value;
string quantity = this.txtQuantity.Text.Trim();
string productID = this.txtProductID.Text.Trim();
string content = this.txtRemarks.Text.Trim();
string unit = this.txtUnit.Text.Trim();
string price = this.txtPrice.Text.Trim();
WX.Ass.Log.MODEL logModel = WX.Ass.Log.NewDataModel();
logModel.Type.value = type;
logModel.OpUserID.value = opUserID;
logModel.OpTime.value = opTime;
logModel.OpIP.value = opIP;
logModel.UserID.value = userId;
logModel.DepartmentID.value = departmentId;
//logModel.Deadline.value = deadline;
if (string.IsNullOrEmpty(maturityDate))
{
logModel.MaturityDate.set(DBNull.Value);
}
else
{
logModel.MaturityDate.value = maturityDate;
}
logModel.Quantity.value = quantity;
logModel.ProductID.value = productID;
logModel.Content.value = content;
logModel.Unit.value = unit;
logModel.Price.value = price;
int singleRow = logModel.Save();
int row = 0;
if (singleRow > 0)
{
if (this.PID.Value != "0")
{
XSql.Execute("EXEC Assets_AddConsuming " + this.PID.Value + "," + this.txtQuantity.Text + ",'" + this.txtProductID.Text + "'");
Equipment.MODEL equipmentModel = Equipment.NewDataModel();
equipmentModel.DepartmentID.value = departmentId;
equipmentModel.UserID.value = userId;
equipmentModel.ProductID.value = productID;
equipmentModel.Quantity.value = quantity;
equipmentModel.AddDate.value = opTime;
equipmentModel.Price.value = price;
equipmentModel.Unit.value = unit;
equipmentModel.Remark.value = content;
equipmentModel.Save();
if (row > 0)
{
WX.Main.AddLog(WX.LogType.Default, "产品领用添加成功！", null);
}
}
}
if (singleRow > 0)
{
ULCode.Debug.Confirm("产品领用添加成功！", "Ass_AddConsuming.aspx", "Ass_AssetsList.aspx");
}
else
{
ULCode.Debug.Alert("产品领用添加失败！", "Ass_AddConsuming.aspx");
}
}
