我在局域网内建了个WEB SERVICE,SQL SERVER数据库与其在同一台机器上,在WINCE 里用SQLITE数据库, 通过WEBSERVICE将sql server里的相关信息下传至SQLITE中,在对wince 的SQLITE进行相关修改后,要通过什么方式再上传到WEBSERVICE 的SQL SERVER里,请给个建议,谢谢!我用的是VS2008!
webservice 端 代码:
public void strLD(string _billid,string _hname,string
_wcode,string num)
{
string FeeWare = "FeeWare_"
+Year();
//string FeeWare =
"FeeWare_2013";
int order =
FeeOrder(_billid);
string date
=accountD();//取本地的相关值
string billid
=_billid;//由客户端的参数传过来的账单序号
int feeorder = order +
1;
string housename =
_hname;//由客户端的参数传过来的房间名称
string warecode =_wcode
;
double salenum =Convert.ToDouble(num);
string SQLstr = " insert into " +
FeeWare +
"(feeorder,accountdate,accountbillid,warecode,warename,wareclass,salenum,saleprice,salemoney,feemode,unit,parentcode,parentname,feewarestate,discountrate,accountstate,discountmoney,printnums,rootcode,rootname,ifbillx)
select " + feeorder + " ,‘" + date + "‘," + _billid +
",warecode,warename,wareclass," + salenum + ",saleprice," + salenum +
"*saleprice,0,unit,parentcode,parentname,‘PDA点单‘,1,1,0,0,rootcode,rootname,0
from wares where warecode=" + warecode +
"";
Db.getObjectExeNonQuery(SQLstr);
}
public static int FeeOrder(string
billid)
{
string
FeeWare = "feeware_" +
Year();
string SQLstr = "select top 1 feeorder from " + FeeWare + " where
accountbillid=" + billid + " order by feeorder
desc";
int
order =
Db.getExecuteScalar(SQLstr);
//
if
(order ==
-1)
{
return order =
0;
}
else
{
return
order;
}
}
public static string
Year()
{
string y
= accountD().Substring(0,
4);
return
y;
}
public static string
accountD()
{
string
SQLstr = "select accountdate from account_para where
ifendaccount=‘false‘and
ifaccountdate=‘true‘";
string d =Convert.ToString(
Db.objExecuteScalar(SQLstr));
return d;
}