コード例 #1
0
    public bool AddStroageInfo(storageInfo storage)
    {
        string str  = "";
        string str2 = str + "insert into storage_register" + "(supplier,itemname,validatedepartment,instorageid,outstoragename,outstroageid,pmid)";

        return(publicDbOpClass.NonQuerySqlString(str2 + "values('" + storage.Supplier + "','" + storage.ItemName + "','" + storage.ValidateDepartment + "','" + storage.InStorageId + "','" + storage.OutStorageName + "','" + storage.OutStroageid + "','" + storage.Pmid + "')"));
    }
コード例 #2
0
    public bool UpdateStroageInfo(storageInfo storage)
    {
        object obj2 = (((((("" + "update storage_register set ") + "supplier='" + storage.Supplier + "',") + "itemName='" + storage.ItemName + "',") + "validateDepartment='" + storage.ValidateDepartment + "',") + "inStorageId='" + storage.InStorageId + "',") + "outStorageName='" + storage.OutStorageName + "',") + "outStroageid='" + storage.OutStroageid + "'";

        return(publicDbOpClass.NonQuerySqlString(string.Concat(new object[] { obj2, "where id=", storage.Id, " and pmid='", storage.Pmid, "'" }).ToString()));
    }