/// <summary> /// 插入或更新一条宴请申请记录 /// </summary> /// <param name="id"></param> /// <param name="ei"></param> public static void SetEntertainApplyByID(int id, EntertainApply ei) { SqlConnection conn = new SqlConnection(connString); SqlCommand cmd; bool isExist = HasEntertainApplyInfo(id); if (isExist) { cmd = new SqlCommand("UPDATE [EntertainApplies] SET [StafffName] = @StaffName, [Departments] = @Departments, [Manager] = @Manager, [ApplyDate] = @ApplyDate, [TreatDate] = @TreatDate, [Reason] = @Reason, [Treated] = @Treated, [Budget] = @Budget,[TreatStandard]=@TreatStandard, [TreatStyle] = @TreatStyle, [ApproveProcess] = @ApproveProcess WHERE [ApplyID] = @ApplyID", conn); } else { cmd = new SqlCommand("INSERT INTO [EntertainApplies] ([StaffName], [Department], [ApplyDate],[TreatDate],[Manager],[Reason],[Treated],[Budget],[TreatStandard], [TreatStyle],[ApproveProcess]) VALUES (@StaffName, @Department, @ApplyDate,@TreatDate,@Manager,@Reason,@Treated,@Budget,@TreatStandard, @TreatStyle,@ApproveProcess)", conn); } cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = ei.staffName; cmd.Parameters.Add("@Department", SqlDbType.VarChar).Value = ei.department; cmd.Parameters.Add("@Manager", SqlDbType.VarChar).Value = ei.manager; cmd.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = ei.applyDate; cmd.Parameters.Add("@TreatDate", SqlDbType.DateTime).Value = ei.treatDate; cmd.Parameters.Add("@TreatStandard", SqlDbType.VarChar).Value = ei.treatStandard; cmd.Parameters.Add("@Reason", SqlDbType.VarChar).Value = ei.reason; cmd.Parameters.Add("@Treated", SqlDbType.VarChar).Value = ei.treated; cmd.Parameters.Add("@Budget", SqlDbType.Float).Value = ei.budget; cmd.Parameters.Add("@TreatStyle", SqlDbType.VarChar).Value = ei.treatStyle; cmd.Parameters.Add("@TreatStandard", SqlDbType.VarChar).Value = ei.treatStandard; cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = ei.approveProcess; conn.Open(); //同时在标准化申请表中插入一条记录 int recordId = Convert.ToInt32(cmd.ExecuteScalar()); if (!isExist) { SqlCommand cmd2 = new SqlCommand("INSERT INTO [AllApplies] ( [ApplyStaff], [ApplyDate], [ApplyType], [NextApprover], [RecordID], [Result]) VALUES (@ApplyStaff, @ApplyDate, @ApplyType, @NextApprover, @RecordID, @Result)", conn); cmd2.Parameters.Add("@ApplyStaff", SqlDbType.VarChar).Value = ei.staffName; cmd2.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = DateTime.Now; cmd2.Parameters.Add("@ApplyType", SqlDbType.VarChar).Value = "宴请申请"; cmd2.Parameters.Add("@RecordID", SqlDbType.Int).Value = recordId; cmd2.Parameters.Add("@NextApprover", SqlDbType.VarChar).Value = BasicInfo.GetOrganizationResponsible(); cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false; cmd2.ExecuteNonQuery(); } conn.Close(); }