예제 #1
0
 public int Insert(M_User_Signin model)
 {
     return(Sql.insert(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #2
0
    public int AddContent(DataTable ContentDT, M_CommonData model)
    {
        int itemid = 0;

        if (!string.IsNullOrEmpty(model.TableName) && ContentDT.Rows.Count > 0)
        {
            string sql = InsertSql(ContentDT);
            if (!string.IsNullOrEmpty(sql))
            {
                string         strSql = "Insert Into " + model.TableName + sql + ";select @@IDENTITY AS newID";
                SqlParameter[] sp     = ContentPara(ContentDT);
                itemid = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp));
            }
        }
        string strSql3 = "select max(OrderID) from ZL_CommonModel";
        int    OrderID = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql3, null)) + 1;

        model.ItemID  = itemid;
        model.OrderID = OrderID;
        //throw new Exception(model.ItemID.ToString() + ":" + itemid);
        // model.GetParameters(model)
        return(Sql.insertID("ZL_CommonModel", model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
    }
예제 #3
0
 public int Insert(M_EDU_AutoPK model)
 {
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #4
0
 public int Insert(M_Pro_Progress model)
 {
     if (model.OrderID == 0)
     {
         model.OrderID = GetMaxOrder(model.ProID);
     }
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #5
0
        public int Add(M_PageReg m_PageReg)
        {
            string strSQL = "INSERT INTO [" + strTableName + "](" + BLLCommon.GetFields(m_PageReg) + ")VALUES(" + BLLCommon.GetParas(m_PageReg) + ")";

            return(DataConverter.CLng(SqlHelper.ExecuteScalar(CommandType.Text, strSQL, m_PageReg.GetParameters())));
        }
예제 #6
0
 public int Insert(M_Shop_FareTlp model)
 {
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #7
0
 public static int Insert(M_Com_VisitCount model)
 {
     return(Sql.insertID(model.TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #8
0
 public int insert(M_Adbuy model)
 {
     return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #9
0
 public int Insert(M_Code_Page model)
 {
     return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #10
0
 public int Insert(M_User_Plat model)
 {
     SyncUB(model);
     model.PK = "";
     return(Sql.insert("ZL_User_Plat", model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #11
0
 public int Insert(M_Order_Repair model)
 {
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #12
0
 public int Insert(M_Exam_Answer model)
 {
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #13
0
 public int Insert(M_Content_Chart model)
 {
     return(Sql.insert(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #14
0
 public int Insert(M_OA_DocSigned model)
 {
     return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
예제 #15
0
 //-----------------Insert
 public int Insert(M_IDC_DBList model)
 {
     return(Sql.insert(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }