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"); } }