示例#1
0
 internal DataTable DL_Save(PL_PFCharges plobj)
 {
     try
     {
         con             = Connection.SetConnection();
         cmd             = new SqlCommand("SP_PFCharges", con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@ind", plobj.Ind);
         cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode);
         cmd.Parameters.AddWithValue("@month", plobj.month);
         cmd.Parameters.AddWithValue("@empno", plobj.EmpNo);
         cmd.Parameters.AddWithValue("@Basic", plobj.Basic);
         cmd.Parameters.AddWithValue("@Grade", plobj.Grade);
         cmd.Parameters.AddWithValue("@DA", plobj.DA);
         cmd.Parameters.AddWithValue("@PF", plobj.PF);
         cmd.Parameters.AddWithValue("@AdminCharge", plobj.AdminCharge);
         cmd.Parameters.AddWithValue("@SalTypeInd", plobj.SalTypeInd);
         da = new SqlDataAdapter(cmd);
         dt = new DataTable();
         da.Fill(dt);
         return(dt);
     }
     catch { return(dt); }
     finally { con.Close(); con.Dispose(); }
 }
示例#2
0
        public DataTable SavePFCharges(PL_PFCharges plobj)
        {
            DataTable    dt    = new DataTable();
            DL_PFCharges dlobj = new DL_PFCharges();

            dt = dlobj.DL_Save(plobj);
            return(dt);
        }