コード例 #1
0
ファイル: BLPrevSoln.cs プロジェクト: ghanigreen/OnlineCRM
 public int Ex_DML(string u)
 {
     try
     {
         int b = d.RunDMLCommand(s, u, "tblqrydetails");
         return(b);
     }
     catch (Exception ex)
     {
         throw new ArgumentException(ex.Message);
     }
 }
コード例 #2
0
 public DataSet In_Dat()
 {
     try
     {
         string   t, u;
         DateTime dt = System.DateTime.Now;
         t = "insert into tblqrydetails(Cus_Name,Cus_Eml_Id,Cus_Con_No,Qry_Text,Qry_Dt) values('" + Cus_Name + "','" + EMl + "','" + Con_No + "','" + QryTxt + "','" + dt + "')";
         u = "select Qry_Id from tblqrydetails where Cus_Name='" + Cus_Name + "' and Cus_Eml_Id='" + EMl + "' and Cus_Con_No='" + Con_No + "' and Qry_Text LIKE '" + QryTxt + "' and Qry_Dt='" + dt + "'";
         int     i = d.RunDMLCommand(s, t, "tblqrydetails");
         DataSet j = d.RunDRLCommand(s, u, "tblqrydetails");
         return(j);
     }
     catch (Exception ex)
     {
         throw new ArgumentException(ex.Message);
     }
 }