public static DataTable SelectAll() { SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [User Name] = [Login].[User_Name] " + " ,[Password] = [Login].[Password] " + "FROM " + " [Login] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; DataTable dt = new DataTable(); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); if (reader.HasRows) { dt.Load(reader); } reader.Close(); } catch (SqlException) { return(dt); } finally { connection.Close(); } return(dt); }
public static List <MarriageRec_Dispensation_Type26> List() { List <MarriageRec_Dispensation_Type26> MarriageRec_Dispensation_TypeList = new List <MarriageRec_Dispensation_Type26>(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Dispensation_Type_ID] " + "FROM " + " [Dispensation_Type] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); MarriageRec_Dispensation_Type26 clsMarriageRec_Dispensation_Type = new MarriageRec_Dispensation_Type26(); while (reader.Read()) { clsMarriageRec_Dispensation_Type = new MarriageRec_Dispensation_Type26(); clsMarriageRec_Dispensation_Type.Dispensation_Type_ID = System.Convert.ToInt16(reader["Dispensation_Type_ID"]); MarriageRec_Dispensation_TypeList.Add(clsMarriageRec_Dispensation_Type); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(MarriageRec_Dispensation_TypeList); }
public static List <MarriageRec_Catholic_Party29> List() { List <MarriageRec_Catholic_Party29> MarriageRec_Catholic_PartyList = new List <MarriageRec_Catholic_Party29>(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Catholic_Party_ID] " + "FROM " + " [Catholic_Party] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); MarriageRec_Catholic_Party29 clsMarriageRec_Catholic_Party = new MarriageRec_Catholic_Party29(); while (reader.Read()) { clsMarriageRec_Catholic_Party = new MarriageRec_Catholic_Party29(); clsMarriageRec_Catholic_Party.Catholic_Party_ID = System.Convert.ToInt16(reader["Catholic_Party_ID"]); MarriageRec_Catholic_PartyList.Add(clsMarriageRec_Catholic_Party); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(MarriageRec_Catholic_PartyList); }
public static List <MarriageRec_Groom21> List() { List <MarriageRec_Groom21> MarriageRec_GroomList = new List <MarriageRec_Groom21>(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Groom_ID] " + "FROM " + " [Groom] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); MarriageRec_Groom21 clsMarriageRec_Groom = new MarriageRec_Groom21(); while (reader.Read()) { clsMarriageRec_Groom = new MarriageRec_Groom21(); clsMarriageRec_Groom.Groom_ID = System.Convert.ToInt32(reader["Groom_ID"]); MarriageRec_GroomList.Add(clsMarriageRec_Groom); } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(MarriageRec_GroomList); }
public static DataTable SelectAll() { SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Catholic Party I D] = [Catholic_Party].[Catholic_Party_ID] " + " ,[Catholic Party Category] = [Catholic_Party].[Catholic_Party_Category] " + "FROM " + " [Catholic_Party] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; DataTable dt = new DataTable(); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); if (reader.HasRows) { dt.Load(reader); } reader.Close(); } catch (SqlException) { return(dt); } finally { connection.Close(); } return(dt); }
public static bool UpdateMarriageData2DB(int nRoleID, MarriageData updateMarriageData, GameClient self) { byte[] dataBytes = DataHelper.ObjectToBytes <MarriageData>(updateMarriageData); byte[] byRoleID = BitConverter.GetBytes(nRoleID); byte[] sendBytes = new byte[dataBytes.Length + 4]; Array.Copy(byRoleID, sendBytes, 4); Array.Copy(dataBytes, 0, sendBytes, 4, dataBytes.Length); return(Global.sendToDB <bool, byte[]>(10185, sendBytes, self.ServerId)); }
/// <summary> /// 更新爱情宣言 /// </summary> public MarryOtherResult ChangeMarriageMessage(GameClient client, string strMessage) { //看看是不是结婚了 if (-1 == client.ClientData.MyMarriageData.byMarrytype) { return(MarryOtherResult.NotMarriaged); } //检查一下宣言长度 todo... 鼠标库表是varchar 128 所以最长就64吧 if (strMessage.Length >= 64) { return(MarryOtherResult.MessageLimit); } //检查屏蔽字 todo... //把自己的爱情宣言更新 client.ClientData.MyMarriageData.strLovemessage = strMessage; //保存数据我自己的爱情宣言 MarryFuBenMgr.UpdateMarriageData2DB(client); SendMarriageDataToClient(client); //取出情侣 GameClient Spouseclient = GameManager.ClientMgr.FindClient(client.ClientData.MyMarriageData.nSpouseID); if (null != Spouseclient) { //更新情侣的爱情宣言 Spouseclient.ClientData.MyMarriageData.strLovemessage = strMessage; //保存数据配偶的爱情宣言 MarryFuBenMgr.UpdateMarriageData2DB(Spouseclient); SendMarriageDataToClient(Spouseclient); } else { //从db查找配偶数据 string tcpstring = string.Format("{0}", client.ClientData.MyMarriageData.nSpouseID); MarriageData SpouseMarriageData = Global.sendToDB <MarriageData, string>((int)TCPGameServerCmds.CMD_DB_GET_MARRY_DATA, tcpstring, client.ServerId); //没有数据? 或者出错? if (null == SpouseMarriageData || -1 == SpouseMarriageData.byMarrytype) { return(MarryOtherResult.Error); } //更新配偶爱情宣言到数据库 MarryFuBenMgr.UpdateMarriageData2DB(client.ClientData.MyMarriageData.nSpouseID, SpouseMarriageData, client); } return(MarryOtherResult.Success); }
private void cbExport_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (new WaitCursor()) { try { MarriageData clsMarriageData = new MarriageData(); if (cbiPDF.IsSelected == true) { if (tiGrid.IsSelected) { clsMarriageData.ExportToPdf("Many", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } else if (tiDetail.IsSelected) { clsMarriageData.ExportToPdf("One", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } } else if (cbiExcel.IsSelected == true) { if (tiGrid.IsSelected) { clsMarriageData.ExportToExcel("Many", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } else if (tiDetail.IsSelected) { clsMarriageData.ExportToExcel("One", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } } else if (cbiWord.IsSelected == true) { if (tiGrid.IsSelected) { clsMarriageData.ExportToWord("Many", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } else if (tiDetail.IsSelected) { clsMarriageData.ExportToWord("One", "Dbo. Dispensation", Grid, (DataRowView)Grid.CurrentItem, Row); } } cbiExport.IsSelected = true; } catch { } } }
public static bool Update(Bride oldBride, Bride newBride) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Bride] " + "SET " + " [Bride_First_Name] = @NewBride_First_Name " + " ,[Bride_Middle_Int] = @NewBride_Middle_Int " + " ,[Bride_Last_Name] = @NewBride_Last_Name " + "WHERE " + " [Bride_ID] = @OldBride_ID " + " AND [Bride_First_Name] = @OldBride_First_Name " + " AND [Bride_Middle_Int] = @OldBride_Middle_Int " + " AND [Bride_Last_Name] = @OldBride_Last_Name " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewBride_First_Name", newBride.Bride_First_Name); updateCommand.Parameters.AddWithValue("@NewBride_Middle_Int", newBride.Bride_Middle_Int); updateCommand.Parameters.AddWithValue("@NewBride_Last_Name", newBride.Bride_Last_Name); updateCommand.Parameters.AddWithValue("@OldBride_ID", oldBride.Bride_ID); updateCommand.Parameters.AddWithValue("@OldBride_First_Name", oldBride.Bride_First_Name); updateCommand.Parameters.AddWithValue("@OldBride_Middle_Int", oldBride.Bride_Middle_Int); updateCommand.Parameters.AddWithValue("@OldBride_Last_Name", oldBride.Bride_Last_Name); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static Bride Select_Record(Bride clsBridePara) { Bride clsBride = new Bride(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Bride_ID] " + " ,[Bride_First_Name] " + " ,[Bride_Middle_Int] " + " ,[Bride_Last_Name] " + "FROM " + " [Bride] " + "WHERE " + " [Bride_ID] = @Bride_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Bride_ID", clsBridePara.Bride_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsBride.Bride_ID = System.Convert.ToInt32(reader["Bride_ID"]); clsBride.Bride_First_Name = System.Convert.ToString(reader["Bride_First_Name"]); clsBride.Bride_Middle_Int = System.Convert.ToString(reader["Bride_Middle_Int"]); clsBride.Bride_Last_Name = System.Convert.ToString(reader["Bride_Last_Name"]); } else { clsBride = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsBride); }
public static bool Add(Bride clsBride) { SqlConnection connection = MarriageData.GetConnection(); string insertStatement = "INSERT " + " [Bride] " + " ( " + " [Bride_First_Name] " + " ,[Bride_Middle_Int] " + " ,[Bride_Last_Name] " + " ) " + "VALUES " + " ( " + " @Bride_First_Name " + " ,@Bride_Middle_Int " + " ,@Bride_Last_Name " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@Bride_First_Name", clsBride.Bride_First_Name); insertCommand.Parameters.AddWithValue("@Bride_Middle_Int", clsBride.Bride_Middle_Int); insertCommand.Parameters.AddWithValue("@Bride_Last_Name", clsBride.Bride_Last_Name); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Update(Log oldLog, Log newLog) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Log] " + "SET " + " [User_Name] = @NewUser_Name " + " ,[Note] = @NewNote " + "WHERE " + " [Log_ID] = @OldLog_ID " + " AND [User_Name] = @OldUser_Name " + " AND [Note] = @OldNote " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewUser_Name", newLog.User_Name); updateCommand.Parameters.AddWithValue("@NewNote", newLog.Note); updateCommand.Parameters.AddWithValue("@OldLog_ID", oldLog.Log_ID); updateCommand.Parameters.AddWithValue("@OldUser_Name", oldLog.User_Name); updateCommand.Parameters.AddWithValue("@OldNote", oldLog.Note); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static Log Select_Record(Log clsLogPara) { Log clsLog = new Log(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Log_ID] " + " ,[User_Name] " + " ,[Note] " + "FROM " + " [Log] " + "WHERE " + " [Log_ID] = @Log_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Log_ID", clsLogPara.Log_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsLog.Log_ID = System.Convert.ToInt32(reader["Log_ID"]); clsLog.User_Name = System.Convert.ToString(reader["User_Name"]); clsLog.Note = System.Convert.ToString(reader["Note"]); } else { clsLog = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsLog); }
public static Parish Select_Record(Parish clsParishPara) { Parish clsParish = new Parish(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Parish_ID] " + " ,[ParishName] " + " ,[KCSJDiocese] " + "FROM " + " [Parish] " + "WHERE " + " [Parish_ID] = @Parish_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Parish_ID", clsParishPara.Parish_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsParish.Parish_ID = System.Convert.ToInt16(reader["Parish_ID"]); clsParish.ParishName = System.Convert.ToString(reader["ParishName"]); clsParish.KCSJDiocese = System.Convert.ToBoolean(reader["KCSJDiocese"]); } else { clsParish = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsParish); }
public static bool Update(Parish oldParish, Parish newParish) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Parish] " + "SET " + " [ParishName] = @NewParishName " + " ,[KCSJDiocese] = @NewKCSJDiocese " + "WHERE " + " [Parish_ID] = @OldParish_ID " + " AND [ParishName] = @OldParishName " + " AND [KCSJDiocese] = @OldKCSJDiocese " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewParishName", newParish.ParishName); updateCommand.Parameters.AddWithValue("@NewKCSJDiocese", newParish.KCSJDiocese); updateCommand.Parameters.AddWithValue("@OldParish_ID", oldParish.Parish_ID); updateCommand.Parameters.AddWithValue("@OldParishName", oldParish.ParishName); updateCommand.Parameters.AddWithValue("@OldKCSJDiocese", oldParish.KCSJDiocese); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static Dispensation Select_Record(Dispensation clsDispensationPara) { Dispensation clsDispensation = new Dispensation(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Dispensation_ID] " + " ,[Dispensation_Category] " + "FROM " + " [Dispensation] " + "WHERE " + " [Dispensation_ID] = @Dispensation_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Dispensation_ID", clsDispensationPara.Dispensation_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsDispensation.Dispensation_ID = System.Convert.ToInt32(reader["Dispensation_ID"]); clsDispensation.Dispensation_Category = System.Convert.ToString(reader["Dispensation_Category"]); } else { clsDispensation = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsDispensation); }
public static Catholic_Party Select_Record(Catholic_Party clsCatholic_PartyPara) { Catholic_Party clsCatholic_Party = new Catholic_Party(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Catholic_Party_ID] " + " ,[Catholic_Party_Category] " + "FROM " + " [Catholic_Party] " + "WHERE " + " [Catholic_Party_ID] = @Catholic_Party_ID " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@Catholic_Party_ID", clsCatholic_PartyPara.Catholic_Party_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsCatholic_Party.Catholic_Party_ID = System.Convert.ToInt16(reader["Catholic_Party_ID"]); clsCatholic_Party.Catholic_Party_Category = System.Convert.ToString(reader["Catholic_Party_Category"]); } else { clsCatholic_Party = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsCatholic_Party); }
public static Login Select_Record(Login clsLoginPara) { Login clsLogin = new Login(); SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [User_Name] " + " ,[Password] " + "FROM " + " [Login] " + "WHERE " + " [User_Name] = @User_Name " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@User_Name", clsLoginPara.User_Name); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsLogin.User_Name = System.Convert.ToString(reader["User_Name"]); clsLogin.Password = System.Convert.ToString(reader["Password"]); } else { clsLogin = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsLogin); }
public static bool Add(Log clsLog) { SqlConnection connection = MarriageData.GetConnection(); string insertStatement = "INSERT " + " [Log] " + " ( " + " [User_Name] " + " ,[Note] " + " ) " + "VALUES " + " ( " + " @User_Name " + " ,@Note " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@User_Name", clsLog.User_Name); insertCommand.Parameters.AddWithValue("@Note", clsLog.Note); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Delete(Bride clsBride) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Bride] " + "WHERE " + " [Bride_ID] = @OldBride_ID " + " AND [Bride_First_Name] = @OldBride_First_Name " + " AND [Bride_Middle_Int] = @OldBride_Middle_Int " + " AND [Bride_Last_Name] = @OldBride_Last_Name " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldBride_ID", clsBride.Bride_ID); deleteCommand.Parameters.AddWithValue("@OldBride_First_Name", clsBride.Bride_First_Name); deleteCommand.Parameters.AddWithValue("@OldBride_Middle_Int", clsBride.Bride_Middle_Int); deleteCommand.Parameters.AddWithValue("@OldBride_Last_Name", clsBride.Bride_Last_Name); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Update(Catholic_Party oldCatholic_Party, Catholic_Party newCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string updateStatement = "UPDATE " + " [Catholic_Party] " + "SET " + " [Catholic_Party_Category] = @NewCatholic_Party_Category " + "WHERE " + " [Catholic_Party_ID] = @OldCatholic_Party_ID " + " AND [Catholic_Party_Category] = @OldCatholic_Party_Category " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewCatholic_Party_Category", newCatholic_Party.Catholic_Party_Category); updateCommand.Parameters.AddWithValue("@OldCatholic_Party_ID", oldCatholic_Party.Catholic_Party_ID); updateCommand.Parameters.AddWithValue("@OldCatholic_Party_Category", oldCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Add(Catholic_Party clsCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string insertStatement = "INSERT " + " [Catholic_Party] " + " ( " + " [Catholic_Party_Category] " + " ) " + "VALUES " + " ( " + " @Catholic_Party_Category " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@Catholic_Party_Category", clsCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Delete(Log clsLog) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Log] " + "WHERE " + " [Log_ID] = @OldLog_ID " + " AND [User_Name] = @OldUser_Name " + " AND [Note] = @OldNote " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldLog_ID", clsLog.Log_ID); deleteCommand.Parameters.AddWithValue("@OldUser_Name", clsLog.User_Name); deleteCommand.Parameters.AddWithValue("@OldNote", clsLog.Note); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Delete(Parish clsParish) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Parish] " + "WHERE " + " [Parish_ID] = @OldParish_ID " + " AND [ParishName] = @OldParishName " + " AND [KCSJDiocese] = @OldKCSJDiocese " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldParish_ID", clsParish.Parish_ID); deleteCommand.Parameters.AddWithValue("@OldParishName", clsParish.ParishName); deleteCommand.Parameters.AddWithValue("@OldKCSJDiocese", clsParish.KCSJDiocese); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public MarryOtherResult ChangeMarriageMessage(GameClient client, string strMessage) { MarryOtherResult result; if (-1 == client.ClientData.MyMarriageData.byMarrytype) { result = MarryOtherResult.NotMarriaged; } else if (strMessage.Length >= 64) { result = MarryOtherResult.MessageLimit; } else { client.ClientData.MyMarriageData.strLovemessage = strMessage; MarryFuBenMgr.UpdateMarriageData2DB(client); this.SendMarriageDataToClient(client, true); GameClient Spouseclient = GameManager.ClientMgr.FindClient(client.ClientData.MyMarriageData.nSpouseID); if (null != Spouseclient) { Spouseclient.ClientData.MyMarriageData.strLovemessage = strMessage; MarryFuBenMgr.UpdateMarriageData2DB(Spouseclient); this.SendMarriageDataToClient(Spouseclient, true); } else { string tcpstring = string.Format("{0}", client.ClientData.MyMarriageData.nSpouseID); MarriageData SpouseMarriageData = Global.sendToDB <MarriageData, string>(10186, tcpstring, client.ServerId); if (SpouseMarriageData == null || -1 == SpouseMarriageData.byMarrytype) { return(MarryOtherResult.Error); } MarryFuBenMgr.UpdateMarriageData2DB(client.ClientData.MyMarriageData.nSpouseID, SpouseMarriageData, client); } result = MarryOtherResult.Success; } return(result); }
public static bool Delete(Catholic_Party clsCatholic_Party) { SqlConnection connection = MarriageData.GetConnection(); string deleteStatement = "DELETE FROM " + " [Catholic_Party] " + "WHERE " + " [Catholic_Party_ID] = @OldCatholic_Party_ID " + " AND [Catholic_Party_Category] = @OldCatholic_Party_Category " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldCatholic_Party_ID", clsCatholic_Party.Catholic_Party_ID); deleteCommand.Parameters.AddWithValue("@OldCatholic_Party_Category", clsCatholic_Party.Catholic_Party_Category); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static DataTable SelectAll() { SqlConnection connection = MarriageData.GetConnection(); string selectStatement = "SELECT " + " [Bride I D] = [Bride].[Bride_ID] " + " ,[Bride First Name] = [Bride].[Bride_First_Name] " + " ,[Bride Middle Int] = [Bride].[Bride_Middle_Int] " + " ,[Bride Last Name] = [Bride].[Bride_Last_Name] " + "FROM " + " [Bride] " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; DataTable dt = new DataTable(); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); if (reader.HasRows) { dt.Load(reader); } reader.Close(); } catch (SqlException) { return(dt); } finally { connection.Close(); } return(dt); }
public static DataTable Search(string sField, string sCondition, string sValue) { SqlConnection connection = MarriageData.GetConnection(); string selectStatement = ""; if (sCondition == "Contains") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] LIKE '%' + LTRIM(RTRIM(@Log_ID)) + '%') " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] LIKE '%' + LTRIM(RTRIM(@User_Name)) + '%') " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] LIKE '%' + LTRIM(RTRIM(@Note)) + '%') " + ""; } else if (sCondition == "Equals") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] = LTRIM(RTRIM(@Log_ID))) " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] = LTRIM(RTRIM(@User_Name))) " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] = LTRIM(RTRIM(@Note))) " + ""; } else if (sCondition == "Starts with...") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] LIKE LTRIM(RTRIM(@Log_ID)) + '%') " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] LIKE LTRIM(RTRIM(@User_Name)) + '%') " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] LIKE LTRIM(RTRIM(@Note)) + '%') " + ""; } else if (sCondition == "More than...") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] > LTRIM(RTRIM(@Log_ID))) " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] > LTRIM(RTRIM(@User_Name))) " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] > LTRIM(RTRIM(@Note))) " + ""; } else if (sCondition == "Less than...") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] < LTRIM(RTRIM(@Log_ID))) " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] < LTRIM(RTRIM(@User_Name))) " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] < LTRIM(RTRIM(@Note))) " + ""; } else if (sCondition == "Equal or more than...") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] >= LTRIM(RTRIM(@Log_ID))) " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] >= LTRIM(RTRIM(@User_Name))) " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] >= LTRIM(RTRIM(@Note))) " + ""; } else if (sCondition == "Equal or less than...") { selectStatement = "SELECT " + " [Log].[Log_ID] " + " ,[Log].[User_Name] " + " ,[Log].[Note] " + "FROM " + " [Log] " + "WHERE " + " (@Log_ID IS NULL OR @Log_ID = '' OR [Log].[Log_ID] <= LTRIM(RTRIM(@Log_ID))) " + "AND (@User_Name IS NULL OR @User_Name = '' OR [Log].[User_Name] <= LTRIM(RTRIM(@User_Name))) " + "AND (@Note IS NULL OR @Note = '' OR [Log].[Note] <= LTRIM(RTRIM(@Note))) " + ""; } SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; if (sField == "Log I D") { selectCommand.Parameters.AddWithValue("@Log_ID", sValue); } else { selectCommand.Parameters.AddWithValue("@Log_ID", DBNull.Value); } if (sField == "User Name") { selectCommand.Parameters.AddWithValue("@User_Name", sValue); } else { selectCommand.Parameters.AddWithValue("@User_Name", DBNull.Value); } if (sField == "Note") { selectCommand.Parameters.AddWithValue("@Note", sValue); } else { selectCommand.Parameters.AddWithValue("@Note", DBNull.Value); } DataTable dt = new DataTable(); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); if (reader.HasRows) { dt.Load(reader); } reader.Close(); } catch (SqlException) { return(dt); } finally { connection.Close(); } return(dt); }
public MarryPartyResult MarryPartyCreate(GameClient client, int partyType, long startTime) { if (!MarryLogic.IsVersionSystemOpenOfMarriage()) { return(MarryPartyResult.NotOpen); } MarryPartyConfigData configData = GetMarryPartyConfigData(partyType); if (null == configData) { return(MarryPartyResult.InvalidParam); } MarriageData marryData = client.ClientData.MyMarriageData; if (marryData.nSpouseID < 0 || marryData.byMarrytype < 0) { return(MarryPartyResult.NotMarry); } int husbandRoleID = 0; int wifeRoleID = 0; string husbandName = ""; string wifeName = ""; if (1 == marryData.byMarrytype) { husbandRoleID = client.ClientData.RoleID; husbandName = client.ClientData.RoleName; wifeRoleID = marryData.nSpouseID; wifeName = MarryLogic.GetRoleName(marryData.nSpouseID); } else { husbandRoleID = marryData.nSpouseID; husbandName = MarryLogic.GetRoleName(marryData.nSpouseID); wifeRoleID = client.ClientData.RoleID; wifeName = client.ClientData.RoleName; } // 必须先添加,以防夫妻重复举行婚宴。。。想不通为什么找我 MarryPartyData partyData = m_MarryPartyDataCache.AddParty(client.ClientData.RoleID, partyType, startTime, husbandRoleID, wifeRoleID, husbandName, wifeName); if (partyData == null) { return(MarryPartyResult.AlreadyRequest); } MarryPartyResult result = MarryPartyResult.Success; byte[] byteData = null; TCPProcessCmdResults dbResult = Global.RequestToDBServer3(Global._TCPManager.tcpClientPool, Global._TCPManager.TcpOutPacketPool, (int)TCPGameServerCmds.CMD_DB_MARRY_PARTY_ADD, string.Format("{0}:{1}:{2}:{3}:{4}:{5}:{6}", client.ClientData.RoleID, partyType, startTime, husbandRoleID, wifeRoleID, husbandName, wifeName), out byteData, client.ServerId ); if (TCPProcessCmdResults.RESULT_FAILED == dbResult || null == byteData || byteData.Length <= 6) { result = MarryPartyResult.AlreadyRequest; } if (result == MarryPartyResult.Success) { // 检查举办所需金币是否足够 if (configData.PartyCost > Global.GetTotalBindTongQianAndTongQianVal(client)) { result = MarryPartyResult.NotEnoughMoney; } if (configData.PartyCost > 0) { // 扣除举办所需金币 if (Global.SubBindTongQianAndTongQian(client, configData.PartyCost, "举办婚宴") == false) { result = MarryPartyResult.NotEnoughMoney; } } } if (result != MarryPartyResult.Success) { if (dbResult != TCPProcessCmdResults.RESULT_FAILED) { try { Global.SendAndRecvData((int)TCPGameServerCmds.CMD_DB_MARRY_PARTY_REMOVE, string.Format("{0}", client.ClientData.RoleID), client.ServerId ); } catch (Exception) { } } m_MarryPartyDataCache.RemoveParty(client.ClientData.RoleID); return(result); } Int32 length = BitConverter.ToInt32(byteData, 0); MarryPartyData dbPartyData = DataHelper.BytesToObject <MarryPartyData>(byteData, 6, length - 2); m_MarryPartyDataCache.SetPartyTime(partyData, dbPartyData.StartTime); SendMarryPartyList(client, partyData); //lock (MarryPartyNPCShowMutex) //{ // if (MarryPartyNPCShow == false) // { // // TODO: add npc // MarryPartyNPCShow = true; // } //} return(result); }
public static MarryResult MarryDivorce(GameClient client, MarryDivorceType divorceType) { MarryResult result; if (!MarryLogic.IsVersionSystemOpenOfMarriage()) { result = MarryResult.NotOpen; } else if (0 >= client.ClientData.MyMarriageData.byMarrytype) { result = MarryResult.NotMarried; } else if (!SingletonTemplate <CoupleArenaManager> .Instance().IsNowCanDivorce(TimeUtil.NowDateTime())) { result = MarryResult.DeniedByCoupleAreanTime; } else { int spouseID = client.ClientData.MyMarriageData.nSpouseID; GameClient spouseClient = GameManager.ClientMgr.FindClient(spouseID); if (divorceType == MarryDivorceType.DivorceForce || divorceType == MarryDivorceType.DivorceFree || divorceType == MarryDivorceType.DivorceFreeAccept) { if (client.ClientData.ExchangeID > 0 || client.ClientSocket.IsKuaFuLogin || client.ClientData.CopyMapID > 0) { return(MarryResult.SelfBusy); } if (-1 != client.ClientData.FuBenID && MapTypes.MarriageCopy == Global.GetMapType(client.ClientData.MapCode)) { return(MarryResult.SelfBusy); } if (null != spouseClient) { if (-1 != spouseClient.ClientData.FuBenID && MapTypes.MarriageCopy == Global.GetMapType(spouseClient.ClientData.MapCode)) { return(MarryResult.TargetBusy); } } if (divorceType == MarryDivorceType.DivorceForce || divorceType == MarryDivorceType.DivorceFree) { if (MarryLogic.ApplyExist(client.ClientData.RoleID)) { return(MarryResult.SelfBusy); } } } int _man = client.ClientData.RoleID; int _wife = spouseID; if (client.ClientData.MyMarriageData.byMarrytype == 2) { DataHelper2.Swap <int>(ref _man, ref _wife); } if (divorceType == MarryDivorceType.DivorceForce) { if (client.ClientData.UserMoney < MarryLogic.DivorceForceCost) { return(MarryResult.MoneyNotEnough); } if (!SingletonTemplate <CoupleWishManager> .Instance().PreClearDivorceData(_man, _wife)) { return(MarryResult.NotOpen); } if (!SingletonTemplate <CoupleArenaManager> .Instance().PreClearDivorceData(_man, _wife)) { return(MarryResult.NotOpen); } if (!GameManager.ClientMgr.SubUserMoney(Global._TCPManager.MySocketListener, Global._TCPManager.tcpClientPool, Global._TCPManager.TcpOutPacketPool, client, MarryLogic.DivorceForceCost, "强制离婚", false, true, false, DaiBiSySType.None)) { } client.ClientData.MyMarriageData.byMarrytype = -1; client.ClientData.MyMarriageData.nSpouseID = -1; MarryFuBenMgr.UpdateMarriageData2DB(client); MarriageOtherLogic.getInstance().ResetRingAttr(client); if (null != spouseClient) { spouseClient.ClientData.MyMarriageData.nSpouseID = -1; spouseClient.ClientData.MyMarriageData.byMarrytype = -1; MarryFuBenMgr.UpdateMarriageData2DB(spouseClient); MarriageOtherLogic.getInstance().ResetRingAttr(spouseClient); MarriageOtherLogic.getInstance().SendMarriageDataToClient(spouseClient, true); if (spouseClient._IconStateMgr.CheckJieRiFanLi(spouseClient, ActivityTypes.JieriMarriage)) { spouseClient._IconStateMgr.AddFlushIconState(14000, spouseClient._IconStateMgr.IsAnyJieRiTipActived()); spouseClient._IconStateMgr.SendIconStateToClient(spouseClient); } } else { string tcpstring = string.Format("{0}", spouseID); MarriageData spouseMarriageData = Global.sendToDB <MarriageData, string>(10186, tcpstring, client.ServerId); if (spouseMarriageData != null && 0 < spouseMarriageData.byMarrytype) { spouseMarriageData.byMarrytype = -1; spouseMarriageData.nSpouseID = -1; MarryFuBenMgr.UpdateMarriageData2DB(spouseID, spouseMarriageData, client); } } MarryPartyLogic.getInstance().MarryPartyRemove(client.ClientData.RoleID, true, client); MarryPartyLogic.getInstance().MarryPartyRemove(spouseID, true, client); MarriageOtherLogic.getInstance().SendMarriageDataToClient(client, true); if (client._IconStateMgr.CheckJieRiFanLi(client, ActivityTypes.JieriMarriage)) { client._IconStateMgr.AddFlushIconState(14000, client._IconStateMgr.IsAnyJieRiTipActived()); client._IconStateMgr.SendIconStateToClient(client); } string msg = string.Format(GLang.GetLang(486, new object[0]), client.ClientData.RoleName); MarryLogic.SendDivorceMail(spouseID, GLang.GetLang(487, new object[0]), msg, spouseClient, client.ServerId); SingletonTemplate <CoupleArenaManager> .Instance().OnDivorce(client.ClientData.RoleID, spouseID); } else if (divorceType == MarryDivorceType.DivorceFree) { if (null == spouseClient) { return(MarryResult.TargetOffline); } if (spouseClient.ClientData.ExchangeID > 0 || spouseClient.ClientSocket.IsKuaFuLogin || spouseClient.ClientData.CopyMapID > 0) { return(MarryResult.TargetBusy); } if (Global.GetTotalBindTongQianAndTongQianVal(client) < MarryLogic.DivorceCost) { return(MarryResult.MoneyNotEnough); } if (!Global.SubBindTongQianAndTongQian(client, MarryLogic.DivorceCost, "申请离婚")) { return(MarryResult.MoneyNotEnough); } MarryLogic.AddMarryApply(client.ClientData.RoleID, MarryApplyType.ApplyDivorce, spouseID); string notifyData = string.Format("{0}:{1}", client.ClientData.RoleID, 1); spouseClient.sendCmd(892, notifyData, false); SingletonTemplate <CoupleArenaManager> .Instance().OnSpouseRequestDivorce(spouseClient, client); } else { if (null == spouseClient) { return(MarryResult.TargetOffline); } if (!MarryLogic.RemoveMarryApply(spouseID, MarryApplyType.ApplyDivorce)) { return(MarryResult.ApplyTimeout); } MarryLogic.RemoveMarryApply(spouseID, MarryApplyType.ApplyNull); if (divorceType == MarryDivorceType.DivorceFreeAccept) { if (SingletonTemplate <CoupleWishManager> .Instance().PreClearDivorceData(_man, _wife) && SingletonTemplate <CoupleArenaManager> .Instance().PreClearDivorceData(_man, _wife)) { client.ClientData.MyMarriageData.byMarrytype = -1; client.ClientData.MyMarriageData.nSpouseID = -1; spouseClient.ClientData.MyMarriageData.byMarrytype = -1; spouseClient.ClientData.MyMarriageData.nSpouseID = -1; MarryFuBenMgr.UpdateMarriageData2DB(client); MarryFuBenMgr.UpdateMarriageData2DB(spouseClient); MarriageOtherLogic.getInstance().SendMarriageDataToClient(client, true); MarriageOtherLogic.getInstance().SendMarriageDataToClient(spouseClient, true); MarriageOtherLogic.getInstance().ResetRingAttr(client); MarriageOtherLogic.getInstance().ResetRingAttr(spouseClient); MarryPartyLogic.getInstance().MarryPartyRemove(client.ClientData.RoleID, true, client); MarryPartyLogic.getInstance().MarryPartyRemove(spouseID, true, client); if (client._IconStateMgr.CheckJieRiFanLi(client, ActivityTypes.JieriMarriage)) { client._IconStateMgr.AddFlushIconState(14000, client._IconStateMgr.IsAnyJieRiTipActived()); client._IconStateMgr.SendIconStateToClient(client); } if (spouseClient._IconStateMgr.CheckJieRiFanLi(spouseClient, ActivityTypes.JieriMarriage)) { spouseClient._IconStateMgr.AddFlushIconState(14000, spouseClient._IconStateMgr.IsAnyJieRiTipActived()); spouseClient._IconStateMgr.SendIconStateToClient(spouseClient); } SingletonTemplate <CoupleArenaManager> .Instance().OnDivorce(client.ClientData.RoleID, spouseID); } else { GameManager.ClientMgr.AddMoney1(Global._TCPManager.MySocketListener, Global._TCPManager.tcpClientPool, Global._TCPManager.TcpOutPacketPool, spouseClient, MarryLogic.DivorceCost, "自由离婚拒绝返还绑金", false); GameManager.ClientMgr.NotifyImportantMsg(Global._TCPManager.MySocketListener, Global._TCPManager.TcpOutPacketPool, client, StringUtil.substitute(GLang.GetLang(488, new object[0]), new object[0]), GameInfoTypeIndexes.Error, ShowGameInfoTypes.ErrAndBox, 0); GameManager.ClientMgr.NotifyImportantMsg(Global._TCPManager.MySocketListener, Global._TCPManager.TcpOutPacketPool, spouseClient, StringUtil.substitute(GLang.GetLang(488, new object[0]), new object[0]), GameInfoTypeIndexes.Error, ShowGameInfoTypes.ErrAndBox, 0); } } else if (divorceType == MarryDivorceType.DivorceFreeReject) { GameManager.ClientMgr.AddMoney1(Global._TCPManager.MySocketListener, Global._TCPManager.tcpClientPool, Global._TCPManager.TcpOutPacketPool, spouseClient, MarryLogic.DivorceCost, "自由离婚拒绝返还绑金", false); string notifyData = string.Format("{0}:{1}", client.ClientData.RoleID, 3); spouseClient.sendCmd(892, notifyData, false); } } result = MarryResult.Success; } return(result); }