计算机毕业论文源代码.docx
《计算机毕业论文源代码.docx》由会员分享,可在线阅读,更多相关《计算机毕业论文源代码.docx(30页珍藏版)》请在冰豆网上搜索。
计算机毕业论文源代码
计算机毕业论文源代码
计算机毕业论文源代码.doc
计算机毕业论文源代码
计算机毕业论文源代码:
会计信息生产社会化仿真系统
1.折旧年限表(pany_zjnx)建表源程序:
CREATETABLE[dbo].[pany_zjnx](
[cname][char](40)COLLATEChinese_PRC_CI_ASNULL,
[obj_name][char](40)COLLATEChinese_PRC_CI_ASNULL,
[zj_years][int]NULL,
[zj_idea][char](40)COLLATEChinese_PRC_CI_ASNULL,
[canzhi][float]NULL
)
2.企业基本情况表(pany_total)建表源程序:
CREATETABLE[dbo].[pany_total](
[_id][int]NOTNULL,
[cname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL,
[ccode][char](18)COLLATEChinese_PRC_CI_ASNULL,
[rmoney][float]NULL,
[faren][char](8)COLLATEChinese_PRC_CI_ASNULL,
[cadd][char](40)COLLATEChinese_PRC_CI_ASNULL,
[kinds][char](20)COLLATEChinese_PRC_CI_ASNULL,
[act_area][text]COLLATEChinese_PRC_CI_ASNULL,
[tel][char](12)COLLATEChinese_PRC_CI_ASNULL,
[cell][char](11)COLLATEChinese_PRC_CI_ASNULL,
[fax][char](12)COLLATEChinese_PRC_CI_ASNULL,
[ccontent][char](8)COLLATEChinese_PRC_CI_ASNULL,
[bank][char](30)COLLATEChinese_PRC_CI_ASNULL,
[bank_num][char](18)COLLATEChinese_PRC_CI_ASNULL,
[zz_num][char](12)COLLATEChinese_PRC_CI_ASNULL,
[tax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[realmoney][float]NULL,
[zz_years][int]NULL,
[fz_date][char](8)COLLATEChinese_PRC_CI_ASNULL,
[fz_jiguan][char](30)COLLATEChinese_PRC_CI_ASNULL,
[hangye][char](10)COLLATEChinese_PRC_CI_ASNULL
)
3.企业初始投资表(pany_cstz)见表源程序:
CREATETABLE[dbo].[pany_cstz](
[cname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL,
[cz_pro][char](40)COLLATEChinese_PRC_CI_ASNULL,
[cz_money][real]NULL,
[cz_man][char](20)COLLATEChinese_PRC_CI_ASNULL,
[cz_code][char](10)COLLATEChinese_PRC_CI_ASNULL,
[cz_date][char](10)COLLATEChinese_PRC_CI_ASNULL,
[cz_percent][char](10)COLLATEChinese_PRC_CI_ASNULL,
[extra][char](60)COLLATEChinese_PRC_CI_ASNULL
)
4.交易总表(contract_total)建表源程序:
CREATETABLE[dbo].[contract_total](
[y][char](10)COLLATEChinese_PRC_CI_ASNULL,
[m][char](10)COLLATEChinese_PRC_CI_ASNULL,
[d][char](10)COLLATEChinese_PRC_CI_ASNULL,
[gname][char](40)COLLATEChinese_PRC_CI_ASNULL,
[gtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[g_add][char](40)COLLATEChinese_PRC_CI_ASNULL,
[gbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL,
[obj_bh][char](10)COLLATEChinese_PRC_CI_ASNULL,
[obj_name][char](20)COLLATEChinese_PRC_CI_ASNULL,
[obj_dw][char](8)COLLATEChinese_PRC_CI_ASNULL,
[obj_sl][int]NULL,
[obj_dj][real]NULL,
[jine][float]NULL,
[tax_per][decimal](18,0)NULL,
[taxe][float]NULL,
[jshj][float]NULL,
[xname][char](40)COLLATEChinese_PRC_CI_ASNULL,
[xtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[x_add][char](40)COLLATEChinese_PRC_CI_ASNULL,
[xbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL,
[zj_years][int]NULL,
[zj_idear][char](40)COLLATEChinese_PRC_CI_ASNULL,
[canzhi][float]NULL,
[pz_num][int]NULL,
[zy][char](30)COLLATEChinese_PRC_CI_ASNULL
)
5.科目表(kmb)建表源程序:
CREATETABLE[dbo].[kmb](
[km_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[km_name][char](26)COLLATEChinese_PRC_CI_ASNULL,
[km_xzh][char](10)COLLATEChinese_PRC_CI_ASNULL,
[jdfx][char]
(2)COLLATEChinese_PRC_CI_ASNULL,
[km_jb][int]NULL
)
6.记账凭证表(jzpz)建表源程序:
CREATETABLE[dbo].[jzpz](
[y][char](10)COLLATEChinese_PRC_CI_ASNULL,
[m][char](10)COLLATEChinese_PRC_CI_ASNULL,
[d][char](10)COLLATEChinese_PRC_CI_ASNULL,
[pz_num][int]NULL,
[z_cname][char](40)COLLATEChinese_PRC_CI_ASNULL,
[d_cname][char](40)COLLATEChinese_PRC_CI_ASNULL,
[km_num][char](10)COLLATEChinese_PRC_CI_ASNULL,
[km_name][char](26)COLLATEChinese_PRC_CI_ASNULL,
[mxkm][char](26)COLLATEChinese_PRC_CI_ASNULL,
[zy][char](30)COLLATEChinese_PRC_CI_ASNULL,
[j_jine][float]NULL,
[d_jine][float]NULL
)
7.时间维表(time_dim)建表源程序:
CREATETABLE[dbo].[time_dim](
[time_num][int]IDENTITY(1,1)NOTNULL,
[y][char](10)COLLATEChinese_PRC_CI_ASNULL,
[m][char](10)COLLATEChinese_PRC_CI_ASNULL,
[d][char](10)COLLATEChinese_PRC_CI_ASNULL
)
8.货物维表(obj_dim)建表源程序:
CREATETABLE[dbo].[obj_dim](
[obj_num][int]IDENTITY(1,1)NOTNULL,
[obj_bh][char](10)COLLATEChinese_PRC_CI_ASNOTNULL,
[obj_name][char](20)COLLATEChinese_PRC_CI_ASNOTNULL,
[obj_dw][char](8)COLLATEChinese_PRC_CI_ASNOTNULL,
[obj_dj][real]NOTNULL
)
9.购货单位维表(g_dim)建表源程序:
CREATETABLE[dbo].[g_dim](
[g_num][int]IDENTITY(1,1)NOTNULL,
[gname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL,
[gtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[g_add][char](40)COLLATEChinese_PRC_CI_ASNULL,
[gbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL
)
10.销货单位维表(x_dim)建表源程序:
CREATETABLE[dbo].[x_dim](
[x_num][int]IDENTITY(1,1)NOTNULL,
[xname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL,
[xtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,
[x_add][char](40)COLLATEChinese_PRC_CI_ASNULL,
[xbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL
)
11.交易事实表(contract_total)建表源程序:
CREATETABLE[dbo].[contract_fact](
[s_num][int]IDENTITY(1,1)NOTNULL,
[g_num][int]NOTNULL,
[x_num][int]NOTNULL,
[time_num][int]NOTNULL,
[obj_num][int]NOTNULL,
[obj_sl][int]NOTNULL,
[jine][float]NOTNULL,
[tax_per][decimal](18,0)NOTNULL,
[taxe][float]NOTNULL,
[jshj][float]NOTNULL
)
计算机毕业论文源代码:
企业人事管理系统的设计与实现
各模块实现的主要源代码
F1.1登录模块的设计与实现的主要代码
if(tbxUserCode.Text.Trim()==““)
{
BigMessageBox.Show(“请您输入用户或密码!
!
”,“警告”,MessageBoxButtons.OK,MessageBoxIcon.Stop);
this.tbxUserCode.Text=““;
this.tbxUserCode.Text=““;
this.tbxUserCode.Focus();
return;
}
else
{
EmployeeInfoemp=null;
switch(User.LoginValidate(tbxUserCode.Text.Trim(),tbxUserPwd.Text.Trim(),outemp))
{
caseUser.LoginResult.NoUser:
{
BigMessageBox.Show(“没有该用户信息”,“用户验证”,MessageBoxButtons.OK,MessageBoxIcon.Stop);
tbxUserCode.Text=““;
tbxUserCode.Focus();
break;
}
caseUser.LoginResult.PasswordError:
{
BigMessageBox.Show(“用户密码错误!
!
”,“用户验证”,MessageBoxButtons.OK,MessageBoxIcon.Stop);
tbxUserPwd.Text=““;
tbxUserPwd.Focus();
break;
}
caseUser.LoginResult.Success:
{
FormMainobjMain=newFormMain();
this.Hide();
objMain.Show();
break;
}
default:
break;
}
}
F1.2登陆实体类:
StringBuilderstrSql=newStringBuilder();
strSql.Append(“selectEmpID,LoginName,LoginCode,Password,RoleID,IsUsed,CreateName,CreateDatetime,RemarkFROMLogin“);
strSql.Append(“whereLoginrCode=“+LoginrCode);
Loginmodel=newLogin();
DataTabledt=DbHelperSQL.Instance.GetDataTable(strSql.ToString());
if(dt.Rows.Count>0)
{
model.EmpNO=dt.Rows[0][“EmpNO”].ToString();
model.LoginName=dt.Rows[0][“LoginName”].ToString();
model.LoginrCode=dt.Rows[0][“LoginCode”].ToString();
model.Password=dt.Rows[0][“Password”].ToString();
if(dt.Rows[0][“RoleID”].ToString()!
=““)
{
model.RoleID=int.Parse(dt.Rows[0][“RoleID”].ToString());
}
model.IsUsed=dt.Rows[0][“IsUsed”].ToString();
model.CreateName=dt.Rows[0][“CreateName”].ToString();
if(dt.Rows[0][“CreateDatetime”].ToString()!
=““)
{
model.CreateDatetime=DateTime.Parse(dt.Rows[0][“CreateDatetime”].ToString());
}
model.Remark=dt.Rows[0][“Remark”].ToString();
returnmodel;
}
else
{
returnnull;
}
检查该员工是否应该是系统用户:
returnDbHelperSQL.Instance.ExecuteScalar(“SELECTLoginIDFROMLoginWHERELoginCode=“+LoginrCode+““);
检查用户编码是否可以使用:
returnDbHelperSQL.Instance.ExecuteScalar(“SELECTLoginrCodeFROMLoginWHERELoginCode=“+LoginrCode+““);
通过LoginID查找相应的密码:
returnDbHelperSQL.Instance.ExecuteScalar(“SelectPasswordfromLoginWhereLoginID=“+LoginID);
F1.3员工管理模块的设计与实现的主要代码
F1.3.1员工管理实现的主要代码:
publicclassBllAttendance
{
///
///增加一条数据
///
publicstaticintAdd(Attendancemodel,DbTransactiontrans)
{
StringBuildersb=newStringBuilder();
sb.Append(“INSERTINTOAttendance(AttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotOut,Outgo,”);
sb.Append(“WorkOut,WorkTime,NumCount,[In],Out,Artificial,[Work],Illness,Thing,Family)”);
sb.Append(“VALUES(@AttenDate,@EmpNo,@Adsum,@Fact,@Late,@Leave,@Absent,@Overtime,@NotIn,@NotOut,@Outgo,”);
sb.Append(“@WorkOut,@WorkTime,@NumCount,@In,@Out,@Artificial,@Work,@Illness,@Thing,@Family)”);
returnDbHelperSQL.Instance.ExcuteTransNonQuery(sb.ToString(),DbHelperSQL.Instance.CreateParamters(sb.ToString(),model),trans);
}
///
///更新一条数据
///
publicstaticintUpdate(Attendancemodel)
{
StringBuildersb=newStringBuilder();
sb.Append(“UPDATEAttendanceSETAdsum=@Adsum,Fact=@Fact,Late=@Late,Leave=@Leave,Absent=@Absent,Overtime=@Overtime,”);
sb.Append(“NotIn=@NotIn,NotOut=@NotOut,Outgo=@Outgo,WorkOut=@WorkOut,WorkTime=@WorkTime,NumCount=@NumCount,”);
sb.Append(“[In]=@In,Artificial=@Artificial,Out=@Out,[Work]=@Work,Illness=@Illness,Thing=@Thing,Family=@FamilyWHEREEmpNo=@EmpNo”);
returnDbHelperSQL.Instance.ExcuteNonQuery(sb.ToString(),DbHelperSQL.Instance.CreateParamters(sb.ToString(),model));
}
///
///删除一条数据
///
publicstaticintDelete(stringEmpNo)
{
StringBuildersb=newStringBuilder();
sb.Append(String.Format(“DELETEFROMAttendanceWHEREEmpNo={0}”,EmpNo));
returnDbHelperSQL.Instance.ExcuteNonQuery(sb.ToString());
}
publicstaticDataTableGetAttenddanceDataTable()
{
StringBuildersb=newStringBuilder();
sb.Append(“SELECTAttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotOut,”);
sb.Append(“Outgo,WorkOut,WorkTime,NumCount,[In],Out,Artificial,[Work],Illness,Thing,FamilyFROMAttendance“);
returnDbHelperSQL.Instance.GetDataTable(sb.ToString());
}
F1.3.2部门管理实现主要代码:
publicclassBLLDepartment
{
///
///增加一条数据
///
publicstaticintAdd(Departmentmodel)
{
StringBuilderstrSql=newStringBuilder();
strSql.Append(“intoDepartment(“);
strSql.Append(“DepartNo,DepartName,DepartDesn,ParentID,Remark”);
strSql.Append(“)”);
strSql.Append(“values(“);
strSql.Append(““+model.DepartNo+“,”);
strSql.Append(““+model.DepartName+“,”);
strSql.Append(““+model.DepartDesn+“,”);
strSql.Append(““+model.ParentID+“,”);
strSql.Append(““+model.Remark+““);
strSql.Append(“)”);
returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString());
}
///
///更新一条数据
///
publicstaticintUpdate(Departmentmodel)
{
StringBuilderstrSql=newStringBuilder();
strSql.Append(“Departmentset“);
strSql.Append(“DepartName=“+model.DepartName+“,”);
strSql.Append(“DepartDesn=“+model.DepartDesn+“,”);
strSql.Append(“ParentID=“+model.ParentID+“,”);
strSql.Append(“Remark=“+model.Remark+““);
strSql.Append(“whereDepartNo=“+model.DepartNo+““);
returnDbHelper