public static string[] Get_Information(string dbname, string PID) { string[] result = new string[3]; string select_string = "select EWID, UpperWID, SortNum from EBudget_WBS where PID='" + PID + "' order by SortNum"; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result[0] += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(1)) { result[1] += "0,"; } else { result[1] += reader.GetInt32(1).ToString() + ","; } if (reader.IsDBNull(2)) { result[2] += "0,"; } else { result[2] += reader.GetInt32(2).ToString() + ","; } } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); //Log exception //Display Error message } if (result[0].Length > 0) { for (int i = 0; i < result.Length; i++) { result[i] = result[i].Substring(0, result[i].Length - 1); } } return(result); }
//public static int getUpperWID_by_UID(string dbname,int nowUID, int[] UID, int[] UpperUID) public static string[] getUpperWID_by_UID(string dbname, int nowUID) { //string[] result1; string temp = ""; //int[] result = 0; string Select_string = "Select EWID,PID,UpperWID from EBudget_WBS where UpperWID=" + nowUID; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(Select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { temp += reader.GetInt32(0).ToString() + ","; //for (int i = 0; i < UID.Length; i++) // { // if (nowUID == UID[i]) // { // result = UpperUID[i]; // break; // } // } } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); } if (temp.Length > 0) { temp = temp.Substring(0, temp.Length - 1); } else { temp = ""; } string[] result1 = temp.Split(','); string[] nextresult; for (int i = 0; i < result1.Length; i++) { nextresult = getUpperWID_by_UID(dbname, int.Parse(result1[i])); } return(result1); }
public static string[] Get_Information(string dbname, string PID) { string[] result = new string[3]; //string select_string = "Select a.ParentID,a.KidID,b.PriceID From Pro_Analysis a left join Pro_Resource b on a.KidID=b.PriceID where ParentID=" + wid; string select_string = "Select a.ParentID,a.KidID,b.PriceID From Pro_Analysis a left join Pro_Resource b on a.KidID=b.PriceID where PID=" + PID; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result[0] += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(1)) { result[1] += "0,"; } else { result[1] += reader.GetInt32(1).ToString() + ","; } result[2] += reader.GetInt32(2).ToString() + ","; } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); //Log exception //Display Error message } if (result[0] != null) { if (result[0].Length > 0) { for (int i = 0; i < result.Length; i++) { result[i] = result[i].Substring(0, result[i].Length - 1); } } } return(result); }
public static string[] Get_EBudget_WBS_Information(string dbname, string Pid) { //string temp = ""; string[] result = new string[4]; //string[] temp_WID = input[0].Split(','); //int count = 0; int[] UpperWID = new int[3]; string Select_string = "Select EWID,CWID,UpperWID from EBudget_WBS where Pid=" + Pid; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(Select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result[0] += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(1)) { result[1] += "0,"; } else { result[1] += reader.GetInt32(1).ToString() + ","; } if (reader.IsDBNull(2)) { result[2] += "0,"; } else { result[2] += reader.GetInt32(2).ToString() + ","; } } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); } return(result); }
public static string[] check_num(string dbname, int UID) { string temp = ""; //string[] result; string[] input = getUpperWID_by_UID(dbname, UID); //string[] temp_WID = input[0].Split(','); //int count = 0; int[] UpperWID = new int[3]; int UpperID = 0; string Select_string = "Select CWID,PID,UpperWID from CBudget_WBS where CWID=" + UID; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(Select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { temp += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(2)) { UpperID = 0; } else { UpperID = reader.GetInt32(2); } string[] newupperID = getUpperWID_by_UID(dbname, UpperID); } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); } return(input); }
public static string[] Get_Pro_Resource_Information(string dbname, string Bid) { string[] result = new string[4]; int[] UpperWID = new int[3]; string Select_string = "Select PriceID,Temp_id from Pro_Resource where bid=" + Bid; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(Select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result[0] += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(1)) { result[1] += "0,"; } else { result[1] += reader.GetInt32(1).ToString() + ","; } } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); } return(result); }
public static bool checkPublicID(string dbname, string ID) { bool result = false; //decimal AnaNum = 1.000M; string SQLString = "select PublicID from UsualWord where PublicID=" + ID; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand SelectList = new SqlCommand(SQLString, conn)) { //conn.Open(); SqlDataReader SelectList_read = SelectList.ExecuteReader(); //DataTableBox = new DataTable(); //DataTableBox.Load(SelectList_read); //for (int i = 0; i < DataTableBox.Columns.Count; i++) //{ // string temp2 = DataTableBox.Columns[i].ColumnName.ToString(); if (SelectList_read.HasRows) { result = false; } else { result = true; } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); //Log exception //Display Error message } return(result); }
public static bool Update_order_num(string dbname, string PID) { bool result = false; int[] input = Sort_LayerCode(dbname, PID); int count = 0; string update_string = "Update EBudget_WBS SET order_Num = "; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); for (int i = 0; i < input.Length; i++) { count++; update_string = "Update EBudget_WBS SET order_Num ='" + count.ToString() + "' WHERE EWID='" + input[i].ToString() + "'"; using (SqlCommand cmd = new SqlCommand(update_string, conn)) { int rows = cmd.ExecuteNonQuery(); if (rows > 0) { result = true; } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); //Log exception //Display Error message } return(result); }
public static bool checkPublicID(string dbname, string ID) { bool result = false; //decimal AnaNum = 1.000M; string SQLString = "select PublicID from ConstructionElement where PublicID=" + ID; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand SelectList = new SqlCommand(SQLString, conn)) { //conn.Open(); SqlDataReader SelectList_read = SelectList.ExecuteReader(); if (SelectList_read.HasRows) { result = false; } else { result = true; } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); //Log exception //Display Error message } return(result); }
public static string[] Get_SubInformation(string dbname, string PID, int UID) { //string temp = ""; string[] result = new string[5]; //string[] temp_WID = input[0].Split(','); //int count = 0; int[] UpperWID = new int[5]; string Select_string = "Select EWID,UpperWID,SortNum,ENumber,LastENumber from EBudget_WBS where pid=" + PID + " Order by order_Num"; try { using (SqlConnection conn = new SqlConnection(DBconnection.connect_string(dbname))) { conn.Open(); using (SqlCommand cmd = new SqlCommand(Select_string, conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result[0] += reader.GetInt32(0).ToString() + ","; if (reader.IsDBNull(1)) { result[1] += "0,"; } else { result[1] += reader.GetInt32(1).ToString() + ","; } if (reader.IsDBNull(2)) { result[2] += "0,"; } else { result[2] += reader.GetInt32(2).ToString() + ","; } if (reader.IsDBNull(3)) { result[3] += "0,"; } else { result[3] += reader.GetDecimal(3).ToString() + ","; } if (reader.IsDBNull(4)) { result[4] += "0,"; } else { result[4] += reader.GetDecimal(4).ToString() + ","; } } } } conn.Close(); } } catch (SqlException ex) { Console.Write(ex.ToString()); } return(result); }