コード例 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Warehouse    w  = new Warehouse();
        WarehouseDAL wd = new WarehouseDAL();

        w.warehouse_id = 1;
        wd             = new WarehouseDAL();
        wd.SelectedByID(ref w);
        w.master_version_id = 1000;
        wd.Update(ref w);
    }
コード例 #2
0
    protected void redoVersion_Click(object sender, EventArgs e)
    {
        if (!checkUser())
        {
            Response.Write("<script>alert('please login.');window.location.href='login.aspx';</script>");
            return;
        }

        Version v2 = new Version();

        v2.version_id = int.Parse(hidValue.Value);
        vd.SelectByID(ref v2);

        Branch b2 = new Branch();

        b2.branch_id = v2.branch_id;
        if (!bd.SelectByID(ref b2))
        {
            Response.Write("<script>alert('invalid argument.')</script>");
            return;
        }

        Warehouse w2 = new Warehouse();

        w2.warehouse_id = v2.warehouse_id;
        if (!wd.SelectedByID(ref w2))
        {
            Response.Write("<script>alert('invalid argument.')</script>");
            return;
        }

        if (b2.branch_name == "master")
        {
            deleteFrom(v2.version_id);
            w2.master_version_id = v2.version_id;
            wd.Update(ref w2);
        }
        else
        {
            deleteFrom(v2.version_id);
        }
        Response.Write("<script>alert('success.');window.location.href='warehouse_page.aspx?wid=" + w2.warehouse_id.ToString() + "&vid=" + w2.master_version_id.ToString() + "';</script>");
    }
コード例 #3
0
ファイル: WarehouseBLL.cs プロジェクト: daniel-ehsure/WMS-NT
 public bool Update(T_JB_WAREHOUSE mo)
 {
     return(dal.Update(mo));
 }
コード例 #4
0
    protected void createButton_Click(object sender, EventArgs e)
    {
        User u = (User)Session["user"];

        if (u == null)
        {
            Response.Write("<script>alert('invalid user 1.');window.opener=null;window.close();</script>");
            return;
        }

        if (v == null)
        {
            Response.Write("<script>alert('invalid vid in create.');window.opener=null;window.close();</script>");
            return;
        }

        if (u.user_id != v.user_id)
        {
            Response.Write("<script>alert('invalid user.');window.opener=null;window.close();</script>");
            return;
        }

        if (name.Value.Length == 0 || desc.Value.Length == 0)
        {
            //error
            Response.Write("<script>alert('invalid name or desc.');</script>");
            return;
        }

        //new version
        Version v2 = new Version();

        v2.version_name = name.Value;
        v2.description  = desc.Value;
        v2.prev_id      = v.version_id; //!
        v2.next_id      = v.next_id;    //!
        v2.warehouse_id = v.warehouse_id;
        v2.user_id      = v.user_id;
        v2.branch_id    = v.branch_id;

        if (!vd.Insert(ref v2))
        {
            Response.Write("<script>alert('insert error 1.');</script>");
            return;
        }

        Version v3 = new Version();

        v3.branch_id    = v.branch_id;
        v3.description  = v.description;
        v3.next_id      = v2.version_id; //warning
        v3.prev_id      = v.prev_id;     //warning
        v3.timestamp    = v.timestamp;
        v3.user_id      = v.user_id;
        v3.version_id   = v.version_id;
        v3.version_name = v.version_name;
        v3.warehouse_id = v.warehouse_id;
        if (!vd.Update(ref v3))
        {
            Response.Write("<script>alert('error 3.');</script>");
            vd.Delete(ref v2);
            vd.Update(ref v);
            return;
        }

        //create files
        if (!FileSystem.CopyFolder(Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v.version_id.ToString(), Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v2.version_id.ToString()))
        {
            vd.Delete(ref v2);
            vd.Update(ref v);
            Response.Write("<script>alert('file error.');</script>");
            return;
        }

        //warnning ; bug here
        Branch b = new Branch();

        b.branch_id = v.branch_id;
        bd          = new BranchDAL();
        bd.SelectByID(ref b);
        if (b.branch_name == "master")
        {
            Warehouse w = new Warehouse();
            w.warehouse_id = v.warehouse_id;
            wd             = new WarehouseDAL();
            wd.SelectedByID(ref w);
            if (w.master_version_id == v.version_id)
            {
                w.master_version_id = v2.version_id;
                wd.Update(ref w);
            }
        }

        Response.Write("<script>alert('create success.');window.location.href='warehouse_page.aspx?wid=" + v.warehouse_id + "&vid=" + v2.version_id + "';</script>");
    }
コード例 #5
0
    protected void createButton_Click(object sender, EventArgs e)
    {
        if (Session["user"] == null)
        {
            Response.Write("<script>alert('please login.');window.location.href='login.aspx';</script>");
            return;
        }

        if (name.Value.Length == 0 || desc.Value.Length == 0)
        {
            Response.Write("<script>alert('emoty data');</script>");
            return;
        }

        //create warehouse
        User         u  = Session["user"] as User;
        Warehouse    w  = new Warehouse();
        WarehouseDAL wd = new WarehouseDAL();

        w.user_id               = u.user_id;
        w.warehouse_name        = name.Value;
        w.warehouse_description = desc.Value;
        if (wd.Insert(ref w))
        {
        }
        else
        {
            Response.Write("<script>alert('error: warehouse insert');</script>");
            return;
        }

        //create first version
        Version    v  = new Version();
        VersionDAL vd = new VersionDAL();

        v.user_id      = u.user_id;
        v.warehouse_id = w.warehouse_id;
        v.version_name = "master";
        v.description  = "master";
        if (vd.Insert(ref v))
        {
            w.master_version_id = v.version_id;
        }
        else
        {
            //delete warehouse
            wd.Delete(ref w);
            Response.Write("<script>alert('error: version insert');</script>");
            return;
        }

        if (wd.Update(ref w))
        {
        }
        else
        {
            //delete warehouse and version
            wd.Delete(ref w);
            vd.Delete(ref v);
            Response.Write("<script>alert('error: warehouse update');</script>");
            return;
        }

        //insert branch
        Branch    b  = new Branch();
        BranchDAL bd = new BranchDAL();

        b.warehouse_id = w.warehouse_id;
        b.user_id      = u.user_id;
        b.start_id     = v.version_id;
        b.end_id       = 0;
        b.branch_name  = "master";
        b.description  = "master";
        if (bd.Insert(ref b))
        {
        }
        else
        {
            Response.Write("<script>alert('error: branch insert');</script>");
            wd.Delete(ref w);
            vd.Delete(ref v);
            return;
        }

        v.branch_id = b.branch_id;
        if (!vd.Update(ref v))
        {
            Response.Write("<script>alert('error: version update');</script>");
            wd.Delete(ref w);
            vd.Delete(ref v);
            bd.Delete(b.branch_id);
            return;
        }

        //crete files
        if (FileSystem.CreateFolder(Server.MapPath("~/") + @"data\" + w.warehouse_id.ToString() + @"\" + v.version_id.ToString()) == false)
        {
            Response.Write("<script>alert('error: file error');</script>");
            wd.Delete(ref w);
            vd.Delete(ref v);
            bd.Delete(b.branch_id);
            return;
        }

        //create success
        Response.Write("<script>alert('create success.');window.location.href='user_page.aspx?uid=" + u.user_id.ToString() + "';</script>");
    }