MyDB.NoreturnSql("insertintoUserList(UserName,PassWord,Controls,GoodsType)values('"+UserNam+"','"+Pwd+"','"+AlignK+"','"+Types+"')");
returntrue;
}
}
publicDataTableGiveSysC()//返回通知列表
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("select*fromSystemTestwhereTestType=0orderByIDdesc");
}
publicDataTableGiveSysX(stringID)
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("select*fromSystemTestwhereID='"+ID+"'");
}
publicstaticDataTableGetBigClass()//返回产品大类
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("select*fromBigClass");
}
publicstaticDataTableGetSmaGoods(stringID)//返回大类所属的产品列表
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("selectID,GoodsNum,GoodsNamefromAllGoodwhereAlignType='"+ID+"'");
}
#region//产品入库
publicintInsertGoods(intAlignGoods,stringGoodCost,intGoodNum,stringGoodMake,stringGoodsBZ,stringInputTime)
{
SqlParameter[]prams={
IntParam("@AlignGoods",SqlDbType.Int,4,AlignGoods),
IntParam("@GoodCost",SqlDbType.VarChar,50,GoodCost),
IntParam("@GoodNum",SqlDbType.Int,4,GoodNum),
IntParam("@GoodMake",SqlDbType.VarChar,50,GoodMake),IntParam("@GoodsBZ",SqlDbType.VarChar,50,GoodsBZ),
IntParam("@InputTime",SqlDbType.VarChar,50,InputTime),
OutParam("@GoodsID",SqlDbType.Int,4)
};
RunInsert("InsertGood",prams);
returnConvert.ToInt32(prams[6].Value);
//returnConvert.ToInt32(prams[0].Value);
}
#endregion
publicstaticvoidUpdateBigGodNum(intNum,intGodID)//入库产品大类数量更新
{
SqlDataBaseMyDb=newSqlDataBase();
MyDb.NoreturnSql("updateAllGoodsetNowNum=NowNum+"+Num+"WhereID='"+GodID+"'");
//return"updateAllGoodsetNowNum=NowNum+'"+Num+"'WhereID='"+GodID+"'";
}
publicstaticvoidOutPut(intNum,intGodID)//出库产品大类数量更新
{
SqlDataBaseMyDb=newSqlDataBase();
MyDb.NoreturnSql("updateAllGoodsetNowNum=NowNum-"+Num+"WhereID='"+GodID+"'");
}
publicstaticvoidInsertGodPaper(intGodsID,intGodsNum,stringGetUser,stringInputUser,stringInputTime,stringPaperType)
{//单据表
SqlDataBaseMyDb=newSqlDataBase();
MyDb.NoreturnSql("InsertIntoGoodPapers(GoodsID,GoodsNum,GetUser,InputUser,GetTime,PaperType)Values('"+GodsID+"','"+GodsNum+"','"+GetUser+"','"+InputUser+"','"+InputTime+"','"+PaperType+"')");
}
publicstaticvoidInsertRecordList(stringInputUser,intGodsID,intGodsNum,stringPaperType,stringInputTime)
{//操作日志表
SqlDataBaseMyDb=newSqlDataBase();
MyDb.NoreturnSql("InsertIntoRecordList(UserName,GoodID,GoodNum,TypesID,RecordTime)Values('"+InputUser+"','"+GodsID+"','"+GodsNum+"','"+PaperType+"','"+InputTime+"')");
}
publicstaticintGetBigGID(intGoodsID)//返回仓库产品所对应的大类产品ID
{
SqlDataBaseMyDb=newSqlDataBase();
ReturnConvert.ToInt32(MyDb.ReturnSQL("selectAlignGoodsfromGoodListwhereID='"+GoodsID+"'"));
}
}
Sum.cs类,库存数据统计文件程序如下:
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
///
///Sum的摘要说明
///
publicclassSum
{
publicSum()
{
//
//TODO:在此处添加构造函数逻辑
//
}
publicstaticDataTableGetKeep()//返回仓库数据集
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("selectID,KeepNamefromKeepNum");
}
publicstaticDataTableGetKeepsNum(intUserID)//返回用户所管理的仓库
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT("selectControls,GoodsTypefromUserListWhereID='"+UserID+"'");
}
publicstaticstringGetKeepsName(intKeepID)
{
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.ReturnSQL("selectKeepNamefromKeepNumwhereID='"+KeepID+"'");
}
publicDataTableGetUserGlist(intUserID)
{
SqlDataBaseMyDb=newSqlDataBase();
DataTableMyDt=(DataTable)MyDb.DT("select*fromUserListWhereID='"+UserID+"'");
StringUserType=Convert.ToString(MyDt.Rows[0]["UserType"]);
stringUserKeep=Convert.ToString(MyDt.Rows[0]["Controls"]);
stringGiveSqlString="";
if(UserType=="1"||UserKeep=="0")
{
GiveSqlString="select*fromView_Dao";
}
else
{
GiveSqlString="select*fromView_DaoWhereKeepID='"+UserKeep+"'";
}
return(DataTable)MyDb.DT(GiveSqlString);
}
}
Keeps.cs类,产品入库文件所有程序如下:
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
///
///Keeps的摘要说明
///
publicclassKeeps
{
publicKeeps()
{
//
//TODO:在此处添加构造函数逻辑
//
}
publicvoidInsertKeep(stringKeepsNam,stringGoodCls)
{
SqlDataBaseMyDb=newSqlDataBase();
MyDb.NoreturnSql("insertintoKeepNum(KeepName,GoodClass)values('"+KeepsNam+"','"+GoodCls+"')");
}
}
Goods.cs类,库存搜索文件所有程序如下:
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
///
///Goods的摘要说明
///
publicclassGoods
{
publicGoods()
{
//
//TODO:在此处添加构造函数逻辑
//
}
publicDataTableSearchPaper(stringKeyWords,stringSearchType)
{
stringSqlString="select*fromView_Papeswhere"+SearchType+"like'%"+KeyWords+"%'orderbyGetTimedesc";
SqlDataBaseMyDb=newSqlDataBase();
returnMyDb.DT(SqlString);
}
publicDataTableSearchGoods(stringKeyWords,stringSearchType)
{
stringSqlString="select*fromAllGoodwhere"+SearchType+"like'%"+KeyWords+"%'";
SqlDataBaseMyDb1=newSqlDataBase();
returnMyDb1.DT(SqlString);
}
}
CheckLogin.cs类,登陆验证文件所有程序如下:
usingSystem;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
///
///CheckLogin的摘要说明
///
publi
上一篇:
ASP_net通用作业批改系统设计+论文(论文和程序)
下一篇:
那些令你为之触动的好句子,感慨万分