基本信息
源码名称：winform 固定资产管理系统源码下载(三层架构)
源码大小：1.79M
文件格式：.zip
开发语言：C#
更新时间：2017-11-29
友情提示：（无需注册或充值，赞助后即可获取资源下载链接）
嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559
本次赞助数额为： 3 元×
微信扫码支付：3 元
×
请留下您的邮箱，我们将在2小时内将文件发到您的邮箱
源码介绍
附加上数据库后，修改 DBConnection.cs中的 数据库 Pwd 密码 即可,登陆账号 jbit 密码 123
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
using FixedAssetMSModel;
namespace FixedAssetMSDAL
{
public class Asset_DAL
{
/// <summary>
/// 插入资产信息
/// </summary>
/// <param name="pAsset_Model"></param>
/// <returns></returns>
public bool InsertAssetInfo(Asset_Model pAsset_Model)
{
bool pd = false;
using (SqlConnection conn = new SqlConnection(DBConnection.ConnString))
{
conn.Open();
string InsertSql = @"insert into Tb_Asset(AssetName,DepotID,DepartID,SortID,AssetXH, AssetZZ,AssetCT, AssetZT,AssetDF,
AssetSL,AssetJD, AssetDJ, AssetJE, AssetZY, AssetZF, AssetYJ, AssetSM) values
(@AssetName,@DepotID,@DepartID,@SortID,@AssetXH, @AssetZZ,@AssetCT, @AssetZT,@AssetDF, @AssetSL, @AssetJD,
@AssetDJ,@AssetJE,@AssetZY,@AssetZF,@AssetYJ, @AssetSM)";
SqlCommand cmd = new SqlCommand(InsertSql, conn);
cmd.Parameters.Add(new SqlParameter("@AssetName", pAsset_Model.AssetName));
cmd.Parameters.Add(new SqlParameter("@DepotID ", pAsset_Model.DepotID));
cmd.Parameters.Add(new SqlParameter("@DepartID", pAsset_Model.DepartID));
cmd.Parameters.Add(new SqlParameter("@SortID", pAsset_Model.SortID));
//cmd.Parameters.Add(new SqlParameter("@AssetFL", pAsset_Model.AssetFL));
cmd.Parameters.Add(new SqlParameter("@AssetXH", pAsset_Model.AssetXH));
cmd.Parameters.Add(new SqlParameter("@AssetZZ", pAsset_Model.AssetZZ));
cmd.Parameters.Add(new SqlParameter("@AssetCT", pAsset_Model.AssetCT));
cmd.Parameters.Add(new SqlParameter("@AssetZT", pAsset_Model.AssetZT));
cmd.Parameters.Add(new SqlParameter("@AssetDF", pAsset_Model.AssetDF));
cmd.Parameters.Add(new SqlParameter("@AssetSL", pAsset_Model.AssetSL));
cmd.Parameters.Add(new SqlParameter("@AssetJD", pAsset_Model.AssetJD));
cmd.Parameters.Add(new SqlParameter("@AssetDJ", pAsset_Model.AssetDJ));
cmd.Parameters.Add(new SqlParameter("@AssetJE", pAsset_Model.AssetJE));
cmd.Parameters.Add(new SqlParameter("@AssetZY", pAsset_Model.AssetZY));
//cmd.Parameters.Add(new SqlParameter("@AssetLZ", pAsset_Model.AssetLZ));
cmd.Parameters.Add(new SqlParameter("@AssetZF", pAsset_Model.AssetZF));
//cmd.Parameters.Add(new SqlParameter("@AssetZS", pAsset_Model.AssetZS));
//cmd.Parameters.Add(new SqlParameter("@AssetYS", pAsset_Model.AssetYS));
//cmd.Parameters.Add(new SqlParameter("@AssetZE", pAsset_Model.AssetZE));
cmd.Parameters.Add(new SqlParameter("@AssetYJ", pAsset_Model.AssetYJ));
cmd.Parameters.Add(new SqlParameter("@AssetSM", pAsset_Model.AssetSM));
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
pd = true;
}
}
return pd;
}
/// <summary>
/// 查询全部资产信息
/// </summary>
/// <returns></returns>
public FixedAssetMSModel.Asset_Model SelectAssetInfo()
{
using (SqlConnection conn = new SqlConnection(DBConnection.ConnString))
{
conn.Open();
string Sql = "select * from View_Asset";
SqlDataAdapter da = new SqlDataAdapter(Sql, conn);
DataSet ds = new DataSet();//创建DataSet实例
da.Fill(ds, "View_Asset");//使用DataAdapter的Fill方法(填充)，调用SELECT命令
FixedAssetMSModel.Asset_Model pAsset_Model = new Asset_Model();
pAsset_Model.AssetDataSet = ds;
return pAsset_Model;
}
}
/// <summary>
/// 修改资产信息
/// </summary>
/// <param name="pAsset_model"></param>
/// <returns></returns>
public bool AssetReviseInfo(Asset_Model pAsset_Model)
{
bool pd = false;
using (SqlConnection conn = new SqlConnection(DBConnection.ConnString))
{
conn.Open();
string ReviseSql = @"update Tb_Asset set AssetName=@AssetName, DepotID=@DepotID,DepartID=@DepartID,SortID=@SortID,
AssetXH=@AssetXH, AssetZZ=@AssetZZ,AssetCT=@AssetCT, AssetZT=@AssetZT,AssetDF=@AssetDF, AssetSL=@AssetSL,
AssetJD=@AssetJD, AssetDJ=@AssetDJ, AssetJE=@AssetJE, AssetZY=@AssetZY, AssetLZ=@AssetLZ,AssetZF=@AssetZF,
AssetZS=@AssetZS,AssetYS=@AssetYS, AssetZE=@AssetZE, AssetYJ=@AssetYJ, AssetSM=@AssetSM where AssetID=@AssetID";
SqlCommand cmd = new SqlCommand(ReviseSql, conn);
cmd.Parameters.Add(new SqlParameter("@AssetID", pAsset_Model.AssetID));
cmd.Parameters.Add(new SqlParameter("@AssetName", pAsset_Model.AssetName));
cmd.Parameters.Add(new SqlParameter("@DepotID ", pAsset_Model.DepotID));
cmd.Parameters.Add(new SqlParameter("@DepartID", pAsset_Model.DepartID));
cmd.Parameters.Add(new SqlParameter("@SortID", pAsset_Model.SortID));
//cmd.Parameters.Add(new SqlParameter("@AssetFL", pAsset_Model.AssetFL));
cmd.Parameters.Add(new SqlParameter("@AssetXH", pAsset_Model.AssetXH));
cmd.Parameters.Add(new SqlParameter("@AssetZZ", pAsset_Model.AssetZZ));
cmd.Parameters.Add(new SqlParameter("@AssetCT", pAsset_Model.AssetCT));
cmd.Parameters.Add(new SqlParameter("@AssetZT", pAsset_Model.AssetZT));
cmd.Parameters.Add(new SqlParameter("@AssetDF", pAsset_Model.AssetDF));
cmd.Parameters.Add(new SqlParameter("@AssetSL", pAsset_Model.AssetSL));
cmd.Parameters.Add(new SqlParameter("@AssetJD", pAsset_Model.AssetJD));
cmd.Parameters.Add(new SqlParameter("@AssetDJ", pAsset_Model.AssetDJ));
cmd.Parameters.Add(new SqlParameter("@AssetJE", pAsset_Model.AssetJE));
cmd.Parameters.Add(new SqlParameter("@AssetZY", pAsset_Model.AssetZY));
cmd.Parameters.Add(new SqlParameter("@AssetLZ", pAsset_Model.AssetLZ));
cmd.Parameters.Add(new SqlParameter("@AssetZF", pAsset_Model.AssetZF));
cmd.Parameters.Add(new SqlParameter("@AssetZS", pAsset_Model.AssetZS));
cmd.Parameters.Add(new SqlParameter("@AssetYS", pAsset_Model.AssetYS));
cmd.Parameters.Add(new SqlParameter("@AssetZE", pAsset_Model.AssetZE));
cmd.Parameters.Add(new SqlParameter("@AssetYJ", pAsset_Model.AssetYJ));
cmd.Parameters.Add(new SqlParameter("@AssetSM", pAsset_Model.AssetSM));
int x = cmd.ExecuteNonQuery();
if (x == 1)
{
pd = true;
}
return pd;
}
}
/// <summary>
/// 查找指定资产的记录
/// </summary>
/// <param name="SelAssetName"></param>
/// <returns></returns>
public FixedAssetMSModel.Asset_Model SelectAssetNameInfo(string SelAssetName)
{
using (SqlConnection conn = new SqlConnection(DBConnection.ConnString))
{
conn.Open();
//string Sql = "select * from Tb_Asset where SelAssetName";
SqlDataAdapter da = new SqlDataAdapter("select * from Tb_Asset where AssetName like '%" SelAssetName "%'", conn);
DataSet ds = new DataSet();//创建DataSet实例
da.Fill(ds, "select * from Tb_Asset where AssetName like '%" SelAssetName "%'");//使用DataAdapter的Fill方法(填充)，调用SELECT命令
FixedAssetMSModel.Asset_Model pAsset_Model = new Asset_Model();
pAsset_Model.AssetDataSet = ds;
ds.Tables[0].Columns["AssetID"].ColumnName = "资产编号";
ds.Tables[0].Columns["DepartID"].ColumnName = "部门编号";
ds.Tables[0].Columns["DepotID"].ColumnName = "仓库编号";
ds.Tables[0].Columns["SortID"].ColumnName = "资产分类编号";
ds.Tables[0].Columns["AssetName"].ColumnName = "资产名称";
ds.Tables[0].Columns["AssetXH"].ColumnName = "型号";
ds.Tables[0].Columns["AssetZZ"].ColumnName = "制造商";
ds.Tables[0].Columns["AssetCT"].ColumnName = "出厂日期";
ds.Tables[0].Columns["AssetZT"].ColumnName = "使用状态";
ds.Tables[0].Columns["AssetDF"].ColumnName = "登记方式";
ds.Tables[0].Columns["AssetSL"].ColumnName = "数量";
ds.Tables[0].Columns["AssetJD"].ColumnName = "计量单位";
ds.Tables[0].Columns["AssetDJ"].ColumnName = "单价";
ds.Tables[0].Columns["AssetJE"].ColumnName = "金额";
ds.Tables[0].Columns["AssetZY"].ColumnName = "资产原值";
ds.Tables[0].Columns["AssetLZ"].ColumnName = "累计折旧";
ds.Tables[0].Columns["AssetZF"].ColumnName = "折旧方法";
ds.Tables[0].Columns["AssetZS"].ColumnName = "折旧月数";
ds.Tables[0].Columns["AssetYS"].ColumnName = "已提月数";
ds.Tables[0].Columns["AssetZE"].ColumnName = "月度折旧额";
ds.Tables[0].Columns["AssetYJ"].ColumnName = "预计净残值";
ds.Tables[0].Columns["AssetSM"].ColumnName = "说明";
return pAsset_Model;
}
}
//public
}
}